MySQL: Difference between revisions
Jump to navigation
Jump to search
| Line 17: | Line 17: | ||
#Type in: <code>CREATE database xbmc_music;</code> and press return | #Type in: <code>CREATE database xbmc_music;</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 | |||
[[Category:How-to]] | [[Category:How-to]] | ||
Revision as of 00:04, 14 November 2011
Notice: These instructions require the latest nightly build of XBMC (pre-Eden v11)
Into about what this is and how cool it is to sync XBMC libraries goes here
Selecting a server
Something about needing to choose which of your XBMC boxes (or NAS box) will be the MySQL server. Needs to be on 24/7 or have wake-on-lan (preferably the former), etc.
Setting up a MySQL server
- Download a copy of MySQL server for your OS: http://dev.mysql.com/downloads/mysql/
- Run the installer and select the Standard configuration
- Create a password when asked
- Select that you want the database to have network access
- Get into the MySQL command line interface.
- Windows: Open the "MySQL Command Line Client" from the MySQL start menu
- Type in:
CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';and press return - Type in:
CREATE database xbmc_video;and press return - Type in:
CREATE database xbmc_music;and press return - Type in:
GRANT ALL ON *.* TO 'xbmc';and press return - Close out the command line tool