2012-04-07, 20:33
Also for people struggling with this (and assuming you are not using separate databases for separate profiles)
As of Eden, you no longer need to either create the databases in MySQL or specify them in advancedsettings, XBMC will do that for you automatically. Just ensure that you grant permission for the MySQL 'xbmc' user to create databases and allow the user to connect from all hosts
As the MySQL root user, DO execute this:
DONT do this any more in MySQL:
In advancedsettings.xml, DONT put in the following lines:
To clarify further, your advancedsettings.xml should just look like this for the MySQL sections (for path substitutions or anything else you require you still need to add that in there in addition to whats below for the MySQL portion)
Eden will create everything for you
As of Eden, you no longer need to either create the databases in MySQL or specify them in advancedsettings, XBMC will do that for you automatically. Just ensure that you grant permission for the MySQL 'xbmc' user to create databases and allow the user to connect from all hosts
As the MySQL root user, DO execute this:
Code:
grant all on *.* to 'xbmc'@'%' identified by 'xbmc';
DONT do this any more in MySQL:
Code:
create database xbmc_video;
create database xbmc_music;
In advancedsettings.xml, DONT put in the following lines:
Code:
<name>xbmc_video</name>
<name>xbmc_music</name>
To clarify further, your advancedsettings.xml should just look like this for the MySQL sections (for path substitutions or anything else you require you still need to add that in there in addition to whats below for the MySQL portion)
Code:
<videodatabase>
<type>mysql</type>
<host>IP_OF_YOUR_MYSQL_SERVER</host>
<user>xbmc</user>
<pass>xbmc</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>IP_OF_YOUR_MYSQL_SERVER</host>
<user>xbmc</user>
<pass>xbmc</pass>
</musicdatabase>
Eden will create everything for you