[PROBLEM] MySQL cannot create db

[mk01]

unfortunately XBMC will try to create NEW DB with upgrades if structure changes. that leads to concern, that you have to give CREATE privilege but can be partially mitigated by telling XBMC to always name the DB with prefix (or instance 'xbmc_') and then you give full including create just to 'xbmc_%'

like this:

INSERT INTO `db` (`Host`, `Db`, `User`, `Select_priv`, `Insert_priv`, `Update_priv`, `Delete_priv`, `Create_priv`, `Drop_priv`, `Grant_priv`, `References_priv`, `Index_priv`, `Alter_priv`, `Create_tmp_table_priv`, `Lock_tables_priv`, `Create_view_priv`, `Show_view_priv`,`Create_routine_priv`, `Alter_routine_priv`, `Execute_priv`, `Event_priv`, `Trigger_priv`) VALUES ('%','xbmc_%','xbmc','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'​,'Y','Y','Y','Y');

second row is dbname, third what you see as 'xbmc' is user name. so in you case 'xbmc' )))

prefix is defined in db definitions in advancedsettings, like pass or user :

<name>xbmc_MyVideos</name> =>

Code:

<videodatabase>
                    <type>mysql</type>
                    <host>192.168.0.110</host>
                    <port>3306</port>
                    <user>xbmc</user>
                    <password>xbmc</password>
<name>xbmc_MyVideos</name>
            </videodatabase>
          
            <musicdatabase>
                    <type>mysql</type>
                    <host>192.168.0.110</host>
                    <port>3306</port>
                    <user>xbmc</user>
                    <password>xbmc</password>
<name>xbmc_MyMusic</name>
            </musicdatabase>

in that case xbmc will always alter only number and lla version will have name xbmc_MyVideos or Music.