Kodi Community Forum

I'm trying to setup mysql for xbmc. I've setup mysql user and databases and i've created an advancedsettings.xml, still xbmc is ignoring these settings.

Code:
10:25:28 T:5300 M:1751556096  NOTICE: Contents of special://profile/advancedsettings.xml are...

                                            <advancedsettings>

                                              <videodatabase>

                                                <type>mysql</type>

                                                <host>192.168.178.32</host>

                                                <port>3306</port>

                                                <user>xbmc</user>

                                                <pass />

                                                <name>xbmc_video</name>

                                              </videodatabase>

                                              <musicdatabase>

                                                <type>mysql</type>

                                                <host>192.168.178.32</host>

                                                <port>3306</port>

                                                <user>xbmc</user>

                                                <pass />

                                                <name>xbmc_music</name>

                                              </musicdatabase>

                                            </advancedsettings>

What does this mean ?

Code:
10:25:29 T:5300 M:1731072000    INFO: essential mysql database information is missing (eg. host, user, pass)

You missed some syntax for the password.

<pass>secret_password_here</pass>

Code:
<videodatabase>

  <type>mysql</type>

  <host>192.168.0.10</host>

  <name>xbmc_video</name>

  <user>xbmc</user>

  <pass>xbmc</pass>

</videodatabase>

See: http://wiki.xbmc.org/index.php?title=Adv...atabase.3E

RudolfR Wrote:You missed some syntax for the password.

<pass>secret_password_here</pass>

Code:
<videodatabase> <type>mysql</type> <host>192.168.0.10</host> <name>xbmc_video</name> <user>xbmc</user> <pass>xbmc</pass> </videodatabase>

See: http://wiki.xbmc.org/index.php?title=Adv...atabase.3E

That's how it is in my advancedsettings, i don't use a password for xbmc. The empty <pass></pass> translates to <pass /> in the logging.

piotr Wrote:That's how it is in my advancedsettings, i don't use a password for xbmc. The empty <pass></pass> translates to <pass /> in the logging.

The username and password it's looking for is for the MySQL DB, not XBMC. Enter the info you used when setting up the mysql user

mhardy Wrote:The username and password it's looking for is for the MySQL DB, not XBMC. Enter the info you used when setting up the mysql user

I have a mysql user XBMC with no password and GRANT ALL and host %. Other remote tools connect fine to the db.

piotr Wrote:I have a mysql user XBMC with no password and GRANT ALL and host %. Other remote tools connect fine to the db.

If i was you i would just add a password to the mysql user and be fine.

Kodi Community Forum

piotr

RudolfR

piotr

mhardy

piotr

Memphiz