2011-11-05, 00:42
I was having problems getting this to work with nightly builds, but after messing around with it I figured out a way to get it to work.
I removed <name>xbmc_video</name> and <name>xbmc_music</name> from the advancedsettings.xml and just let xbmc create the databases.
So I ended up with MyVideos57.db, MyVideos34.db and MyMusic18.db.
Next, instead of just creating user 'xbmc' like the it says in the Wiki, I had to create a unique user for each computer and then grant privileges for each database.... So:
CREATE USER xbmc@nameofcomputer IDENTIFIED BY 'xbmc';
GRANT ALL PRIVILEGES ON MyVideos57.* TO xbmc@'%';
GRANT ALL PRIVILEGES ON MyVideos34.* TO xbmc@'%';
GRANT ALL PRIVILEGES ON MyMusic18.* TO xbmc@'%';
This worked for me so hopefully it will help others like myself who have no MySQL experience.
I removed <name>xbmc_video</name> and <name>xbmc_music</name> from the advancedsettings.xml and just let xbmc create the databases.
So I ended up with MyVideos57.db, MyVideos34.db and MyMusic18.db.
Next, instead of just creating user 'xbmc' like the it says in the Wiki, I had to create a unique user for each computer and then grant privileges for each database.... So:
CREATE USER xbmc@nameofcomputer IDENTIFIED BY 'xbmc';
GRANT ALL PRIVILEGES ON MyVideos57.* TO xbmc@'%';
GRANT ALL PRIVILEGES ON MyVideos34.* TO xbmc@'%';
GRANT ALL PRIVILEGES ON MyMusic18.* TO xbmc@'%';
This worked for me so hopefully it will help others like myself who have no MySQL experience.