Kodi Community Forum

I'm having some trouble with mysql, I have installed it onto a fresh install of linux mint following the instructions on the wiki, I am using the same advanced settings from before as they point to the same assigned local ip. I am at my whits end, i have fully uninstalled mysql and a full install again.

The error im getting is "MyMusic52 [1130](Host '192.168.0.6' is not allowed to connect to this MySQL server" I have done a some googling and found that its linked to permissions, so I uninstalled and tried again, i have tried the flush privileges.

Any help with how to get this working will be greatly appreciated.

Jeff

debug log

KODI 15.2 Git:02e7013 Comp. 19-10-15

Linux Mint 17.2 Cinnamon 32 bit
Ver 2.6.13
Linux Kernel 3.160-38-generic

i686.

PPA install from wiki.

Can you log to mysql and type:
show grants for 'kodi'@'%';

and paste the result here?

(2015-10-21, 16:12)kyungrak Wrote: [ -> ]Can you log to mysql and type:
show grants for 'kodi'@'%';

and paste the result here?

I don't get any output.

Jeff

(2015-10-21, 16:12)kyungrak Wrote: [ -> ]Can you log to mysql and type:
show grants for 'kodi'@'%';

and paste the result here?

Screenshot

Jeff

you have to type ; at the end

(2015-10-21, 16:21)kyungrak Wrote: [ -> ]you have to type ; at the end

My god I dont know how I missed that!!

Thats my problem, when i followed the wiki i missed, the ";" from each line.

I have just redone the tutorial from the wiki and its working now.

Thank you very much for your time and help!!

Jeff