MySQL/Setting up MySQL: Difference between revisions
< MySQL
Jump to navigation
Jump to search
Line 80: | Line 80: | ||
=Windows= | =Windows= | ||
''' | == Installing MySQL on Windows == | ||
#Download a copy of MySQL server from http://dev.mysql.com/downloads/mysql/ | If you have chocolatey installed run '''choco install mysql''' | ||
:'''or''' | |||
#Download a copy of MySQL server from http://dev.mysql.com/downloads/mysql/ | |||
#Select ''Standard configuration'' | #Select ''Standard configuration'' | ||
#Create a password when asked | #Create a password when asked | ||
#Select that you want the database to have network access when prompted during installation. | #Select that you want the database to have network access when prompted during installation. | ||
If you're using a firewall such as the one that's built into Windows, you will need to follow the steps below for the version of windows you installed XBMC/Kodi on. | |||
=== Windows 7/8/8.1 Built-in Firewall === | |||
: Run the following command in powershell or execute all the steps below. | : Run the following command in powershell or execute all the steps below. | ||
'''New-NetFirewallRule -DisplayName "Allow inbound TCP Port 3306 for MySQL" -Direction inbound –LocalPort 3306 -Protocol TCP -Action Allow''' | |||
:#Go to control panel and open Windows Firewall | :#Go to control panel and open Windows Firewall | ||
:#Click on Advanced Settings | :#Click on Advanced Settings | ||
Line 102: | Line 100: | ||
:#For Profile, you can leave it as default (everything checked by default) and hit Next | :#For Profile, you can leave it as default (everything checked by default) and hit Next | ||
:#For Name, set it to '''''MySQL''''' or any name that you will know what it is and click Finished | :#For Name, set it to '''''MySQL''''' or any name that you will know what it is and click Finished | ||
=== Windows XP Built-in Firewall === | |||
:#Open Control Panel and Set to 'Classic View' | :#Open Control Panel and Set to 'Classic View' | ||
:#Double Click on Windows Firewall | :#Double Click on Windows Firewall | ||
Line 110: | Line 108: | ||
:#Set the port number to '''3306''' | :#Set the port number to '''3306''' | ||
:#Choose '''''TCP''''' and click OK | :#Choose '''''TCP''''' and click OK | ||
== Setup users in MySQL for XBMC/Kodi clients == | |||
#Open the "MySQL Command Line Client" from the MySQL start menu | |||
#Enter the following commands: | |||
##Type in: <code>CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';</code> and press return | |||
##Type in: <code>GRANT ALL ON *.* TO 'xbmc';</code> and press return | |||
#Close out the command line tool | |||
{{Note|If XBMC is unable to connect to the MySQL server, returning an error code [1130]:}}<br/> | {{Note|If XBMC is unable to connect to the MySQL server, returning an error code [1130]:}}<br/> |
Revision as of 05:04, 18 November 2014
Share libraries w/MySQL, guide: |
MySQL | Setting up MySQL |
You'll need to choose which of your computers, XBMC devices, or NAS will be the MySQL server. The server needs to be on 24/7 or have wake-on-lan (preferably the former), and needs to have a local static IP. You will probably want the XBMC device that is hosting most or all of your videos and music to also be the MySQL server, but this is not required.
Note: XBMC v13 seems to have fixed the issue with MySQL 5.6, making it safe to use with XBMC.
Please Note: Don't create the MySQL databases on your server. Simply set up the MySQL server itself, as XBMC will create the specific databases by itself.
MySQL can be installed on just about every major OS:
Next step: | Setting up XBMC |