asuswrt merlin mysql kodi dont connect

[Galbeida]

Hello everyone and excuse my English,

I recently bought an ASUS AC66 Router and I installed Merlin firmware. The issue is that I have Mysql installed on the router, so the IP of the router is 192.168.1.1, which is also the mysql server. I installed phpmyadmin, which works perfectly from the main PC with IP 192.168.1.100 and created the user kodi:

CREATE USER 'kodi' IDENTIFIED BY 'kodi';

I give you permissions:

GRANT ALL ON *. * TO 'kodi';

and I create the following advancedsettings:

<advancedsettings>

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

<musicdatabase>
<type>mysql</type>
<host>192.168.1.1</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</musicdatabase>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
</videolibrary>

<network>
<buffermode>1</buffermode>
<cachemembuffersize>209715200</cachemembuffersize>
<readbufferfactor>10</readbufferfactor>
</network>
</advancedsettings>

But when opening kodi I see that it does not connect with the bbdd and the log shows me the following errors:
13:45:32.177 T:2580 ERROR: Unable to open database: MyMusic60 [2003](Can't connect to MySQL server on '192.168.1.1' (10061))
... (here are 20 more lines but changing the number of MyMusic60)
13:46:01.490 T:2580 ERROR: Unable to create new database
13:46:02.502 T:2580 ERROR: Unable to open database: MyVideos107 [2003](Can't connect to MySQL server on '192.168.1.1' (10061))
... (here are 20 more lines but changing the number of MyVideos107)

I read that maybe I had no permissions to access the remote BBDD and added the command my.cnf to the command:

bind-address = 192.168.1.1

I also tried with:

bind-address = 0.0.0.0

But, nothing ever the same result could help me? The PC I use has Windows 10 6bit and the kodi version is 17.3

 

[bilboSNB]

Maybe port 3306 on win 10 needs opening.

Or could sql be listening on the wrong interface?

Storage permissions?