I am not able to connect to my remote MySQL database running on an Ubuntu server
Quote
15:36:24 T:140117900314688 ERROR: Unable to open database: MyVideos99 [2003](Can't connect to MySQL server on '192.168.1.10' (101))
I can ping the server and when I telnet to port 3306, I get a response back
Quote
pmysql_native_password
I've been using MySQL for several months with no problems. I replaced my router today and all the systems on the network still have their old IP address. The user kodi has permission to connect from any host in MySQL.
Here is my advancedsettings.xml
QuoteDisplay More
<videodatabase>
<type>mysql</type>
<host>192.168.1.10</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</videodatabase>
<musicdatabase>
<type>mysql</type>
<host>192.168.1.10</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</musicdatabase>
<videolibrary>