2016-11-12, 21:17
I'm having issues getting mysql working.I did have this setup before using older kodi,currently running 16.1. I have followed the wiki and have checked everything.mysql setup on win7,firewall rule setup,even turned firewall off.Kodi log I get error 1130.so in the wiki it says to " Open the "MySQL Command Line Client" from the MySQL start menu
Enter the following commands:
Type in: CREATE USER 'kodi' IDENTIFIED BY 'kodi'; and press return
Type in: GRANT ALL ON *.* TO 'kodi'; and press return
Close out the command line tool
Note: If Kodi is unable to connect to the MySQL server, returning an error code [1130]:
If this occurs to you, try amending Step 2 above to read GRANT ALL ON *.* TO 'kodi'@'xxx.xxx.xxx.%'; where xxx.xxx.xxx is the first three quadrants of your home network's IP address (192.168.1 for example) and % as the last quadrant to allow addresses on the same subnet to connect. So i'm not sure what to put in the last quadrant.The ip of the client?
Enter the following commands:
Type in: CREATE USER 'kodi' IDENTIFIED BY 'kodi'; and press return
Type in: GRANT ALL ON *.* TO 'kodi'; and press return
Close out the command line tool
Note: If Kodi is unable to connect to the MySQL server, returning an error code [1130]:
If this occurs to you, try amending Step 2 above to read GRANT ALL ON *.* TO 'kodi'@'xxx.xxx.xxx.%'; where xxx.xxx.xxx is the first three quadrants of your home network's IP address (192.168.1 for example) and % as the last quadrant to allow addresses on the same subnet to connect. So i'm not sure what to put in the last quadrant.The ip of the client?