Warning; your Geek-Fu must be strong for this, and if you have to ask, you don’t need it.

Requirements

  • Another computer to act as a server (I’m using a headless Ubuntu 12.04 box, and any differences between operating systems stop once MySQL is set up)
  • Access to an SSH client
  • A text editor

Setup

Roughly based on http://wiki.openelec.tv/index.php?title=Configure_MySQL_database

  1. SSH in the the server (if you need help, find your server’s IP address, and see here)
  2. Install MySQL
    • sudo apt-get install mysql-server
  3. Drill in to the MySQL environment
    • mysql -u root -p

      (if you did not set up a password, just leave it blank and press enter)

  4. Paste the SQL command to create the user, set permissions, and cement everything in
    • CREATE USER 'xbmc' IDENTIFIED BY 'xbmc';
      GRANT ALL ON *.* TO 'xbmc'; FLUSH PRIVILEGES;
  5. Set up OpenELEC to connect to the MySQL Database (Warning: at this stage, I can very little about previous scan results, so am simply wiping everything each time. Takes less energy.)
    1. Connect to the OpenELEC SMB Share “Userdata”
    2. Create “advancedsettings.xml” or edit it if it’s already created. This code goes there:
      1. <advancedsettings>
        <videodatabase>
        <type>mysql</type>
        <host>x.x.x.x</host>
        <port>3306</port>
        <user>xbmc</user>
        <pass>xbmc</pass>
        </videodatabase>
        <musicdatabase>
        <type>mysql</type>
        <host>x.x.x.x</host>
        <port>3306</port>
        <user>xbmc</user>
        <pass>xbmc</pass>
        </musicdatabase>
        </advancedsettings>

        Replace ‘x.x.x.x’ with the Server’s IP Address.

    3.  Save
    4. Go in to the “Database” folder, delete “MyVideos60.db” & “MyMusic18.db”
    5. Reboot the Raspberry