Kodi Community Forum

desktop > ubuntu 12.04 XBMC 11.0
HTPC/Server >XBMCbuntu 11.0

Mysql server is on the xbmcbuntu, i have followed the guide on the wiki
the database is populated from the server

on the desktop
settings are

Code:
<advancedsettings>

    <videodatabase>

        <type>mysql</type>

        <host>192.168.1.114</host>

        <port>3306</port>

        <user>user</user>

        <pass>password</pass>

        <name>xbmc_video</name>

    </videodatabase> 

    <musicdatabase>

        <type>mysql</type>

        <host>192.168.1.114</host>

        <port>3306</port>

        <user>user</user>

        <pass>password</pass>

        <name>xbmc_music</name>

    </musicdatabase>

</advancedsettings>

after i run xbmc i run
tail -f .xbmc/temp/xbmc.log i get

Code:
21:40:43 T:140498969024256   ERROR: Unable to open database: xbmc_video60 [1045](Access denied for user 'user'@'localhost' (using password: YES))

That all looks correct. Make sure your "user" user has the ability to make new DBs on the MySQL server by doing

GRANT ALL ON *.* TO 'user';

in MySQL

i found my problem
i had an extra ">" somewhere in my xml
this was a user error like always >_<

rocker2344

Ned Scott

rocker2344