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 database xbmc_video;</code> and press return | |||
#Type in: <code>CREATE database xbmc_music;</code> and press return | |||
[[Category:How-to]] | [[Category:How-to]] |
Revision as of 00:02, 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