MySQL/Setting up MySQL: Difference between revisions
< MySQL
Jump to navigation
Jump to search
>Jmarcet No edit summary |
>Jmarcet No edit summary |
||
Line 19: | Line 19: | ||
#Get into the MySQL command line utility: <code>$mysql -u root -p</code> | #Get into the MySQL command line utility: <code>$mysql -u root -p</code> | ||
#Enter the following commands: | #Enter the following commands: | ||
##Type in: <code>CREATE USER 'xbmc | ##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 | ##Type in: <code>GRANT ALL ON *.* TO 'xbmc';</code> and press return | ||
#Close out the command line tool with <code>\q</code> | #Close out the command line tool with <code>\q</code> | ||
Line 35: | Line 35: | ||
#*Enter your MySQL root password as set above, or just press enter if you didn't set one to log in with a blank password | #*Enter your MySQL root password as set above, or just press enter if you didn't set one to log in with a blank password | ||
#Enter the following commands: | #Enter the following commands: | ||
##Type in: <code>CREATE USER 'xbmc | ##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 | ##Type in: <code>GRANT ALL ON *.* TO 'xbmc';</code> and press return | ||
#Close out the command line tool with <code>\q</code> | #Close out the command line tool with <code>\q</code> | ||
Line 45: | Line 45: | ||
#Now to set up the "xbmc" user in MySQL and give it access. Launch Terminal.app on your Mac and issue the following commands, one line at a time: | #Now to set up the "xbmc" user in MySQL and give it access. Launch Terminal.app on your Mac and issue the following commands, one line at a time: | ||
##<code>sudo /usr/local/mysql/bin/mysql</code> | ##<code>sudo /usr/local/mysql/bin/mysql</code> | ||
##<code>CREATE USER 'xbmc | ##<code>CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';</code> | ||
##<code>GRANT ALL ON *.* TO 'xbmc';</code> | ##<code>GRANT ALL ON *.* TO 'xbmc';</code> | ||
##<code>exit</code> | ##<code>exit</code> | ||
Line 71: | Line 71: | ||
#Open the "MySQL Command Line Client" from the MySQL start menu | #Open the "MySQL Command Line Client" from the MySQL start menu | ||
#Enter the following commands: | #Enter the following commands: | ||
##Type in: <code>CREATE USER 'xbmc | ##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 | ##Type in: <code>GRANT ALL ON *.* TO 'xbmc';</code> and press return | ||
#Close out the command line tool | #Close out the command line tool |
Revision as of 15:45, 27 April 2013
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.
On a computer
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 |