iOS MySQL connection problem with iPAD

[amet]

Code: Select all

20:13:53 T:6147436544   ERROR: Unable to open database: MyMusic52 [1045](Access denied for user 'kodi'@'DiskStation' (using password: YES))

there is definitely an issue with your setup, you have access denied error which usually means that you have only allowed connection with kodi user from specific IP.

see here for more info http://kodi.wiki/view/MySQL/Setting_up_MySQL

[luckynd]

I've sent you screenshots of the MySQL config for iPad and iPhone.
You will see (as I said since the start ) that the config is the same.
From what I see in the log:< 'kodi' @ 'DiskStation' >, MrMC is using the server name (or BD alias name, I don't know to what it correspond) instead of the IP (that I've used). So it resolve a (network/DB) name instead of using the IP.
I tried to change it to DiskStationServ, but it is still continuing to use the old name.
Do you have any idea?

Thanks

[amet]

it resolves to some IP address that doesn't match with your config

Code: Select all

 GRANT ALL ON *.* TO 'kodi';

is the one that allows all IP addresses to connect, if iPad IP address is not allowed to connect then not much it can be done from app side

[luckynd]

OK, normally I've configured the grant for Kodi with all grant (I've followed the Kodi post). But I will re-check it once I will be back to my home...

[luckynd]

"Flush hosts" on MariaDB has solved the problem

EDIT: obviously