[map7]

I'm running Kodi 17.6 on Debian Stretch and I've setup my advancedsettings.xml as follows

Code:

<advancedsettings>
  <videodatabase>
    <type>mysql</type>
    <host>10.1.1.10</host>
    <port>3306</port>
    <user>kodi</user>
    <pass>kodi</pass>
  </videodatabase>

  <musicdatabase>
    <type>mysql</type>
    <host>10.1.1.10</host>
    <port>3306</port>
    <user>kodi</user>
    <pass>kodi</pass>
  </musicdatabase>

  <videolibrary>
    <importwatchedstate>true</importwatchedstate>
    <importresumepoint>true</importresumepoint>
  </videolibrary>
</advancedsettings>

I've followed the instructions here https://kodi.wiki/view/MySQL/Setting_up_Kodi but when I start kodi I get these error messages within my kodi.log file

Code:

11:43:59.068 T:140150878201600   ERROR: Unable to open database: MyMusic60 [2013](Lost connection to MySQL server at 
'reading initial communication packet', system error: 0 "Internal error/check (Not system error)")

I've tried enabling debug logging but that didn't create the database. 

I can login to mysql as 'kodi' with password 'kodi' and create databases so I don't think it's a permissions thing.

[map7]

As always just after posting this I've found the solution, it was to add the following to my /etc/hosts.allow

mysqld: 10.1.1.
mysqld: 127.0.0.1

Then I tested locally

mysql --host=10.1.1.10 --user=kodi --password=kodi

Which then works, then I just restarted kodi and all the tables were created

[Klojum]

Thread marked solved.