MySQL/Setting up MySQL: Difference between revisions
< MySQL
Jump to navigation
Jump to search
(→Windows: updated firewall rules information) |
|||
Line 86: | Line 86: | ||
##Type in: <code>GRANT ALL ON *.* TO 'xbmc';</code> and press return | ##Type in: <code>GRANT ALL ON *.* TO 'xbmc';</code> and press return | ||
#Close out the command line tool | #Close out the command line tool | ||
# | #If you're using a firewall such as the one that's built into Windows, you will need to do this next step. | ||
:*'''Windows 7 Built-in Firewall''' | |||
:#Go to control panel and open Windows Firewall | |||
:#Click on Advanced Settings | |||
# | :#Click on Inbound Rules, then New Rule | ||
# | :#For the Rule Type, choose '''''Port''''' and hit Next | ||
# | :#For Protocol and Ports, select TCP protocol and type in '''''3306''''' for the '''''Specific local ports''''' and hit Next | ||
# | :#For Action, leave it at default which is '''''Allow the connection''''' 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 | |||
:*'''Windows XP Built-in Firewall''' | |||
:#Open Control Panel and Set to 'Classic View' | |||
:#Double Click on Windows Firewall | |||
##Click on | :#Click on tab that says Exceptions | ||
:#Click on Add Port | |||
# | :#Name it '''''MySQL''''' or any other name | ||
# | :#Set the port number to '''3306''' | ||
:#Choose '''''TCP''''' and click OK | |||
{{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 10:10, 5 January 2014
HOW-TO:Sync multiple libraries/Contents
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.
NOTICE: Users are reporting issues with MySQL 5.6. Use MySQL 5.5 instead. |
MySQL can be installed on just about every major OS:
- If your library loads slowly with MySQL then you may wish to check out these MySQL speed-up tweaks.
Next step: | Setting up XBMC |