MySQL: Difference between revisions
Jump to navigation
Jump to search
Line 13: | Line 13: | ||
#Get into the MySQL command line interface. | #Get into the MySQL command line interface. | ||
#:'''Windows:''' Open the "MySQL Command Line Client" from the MySQL start menu | #:'''Windows:''' Open the "MySQL Command Line Client" from the MySQL start menu | ||
#Type in: <code>CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';</code> and press return | ##Type in: <code>CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';</code> and press return | ||
#Type in: <code>CREATE database xbmc_video;</code> and press return | ##Type in: <code>CREATE database xbmc_video;</code> and press return | ||
#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 | #Close out the command line tool | ||
Revision as of 00:13, 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 the 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
Setting up XBMC
- Open XBMC on the computer that has the library you want to share (If you have not created a library yet you can skip to X)
- Export the Video Library by doing the following:
- Go to System/Settings -> Video -> Library and select Export library
- Select Single file
- Export the Music Library by doing the following:
- Go to System/Settings -> Music -> Library and select Export library
- Select Single file