Last post Nov 26, 2010 05:56 AM by rohitmahadik
Nov 26, 2010 02:42 AM|Muhammad Kashan Khan|LINK
i have installed mysql server on linux on remote server.
now i want to connect it from my local mysql server which is on windows.
whenever i connect to mysql server i get the error
Error No: 1130
Host '192.168.15.222' is not allowed to connect to this mysql server.
this= my remote server which is on linux...
please help how to connect it?
Nov 26, 2010 05:48 AM|krisrajz|LINK
Are you able to ping/telnet the remote MySQL server?
Check any firewall/Anti virus on the remote MySQL Server is blocking any incoming/outgoing connection to MySQL server
Nov 26, 2010 05:56 AM|rohitmahadik|LINK
HI, This will surely help u out. i had faced the same sort of problem some time back n i have managed to get rid from that in below fashion.
In your server , login with server credentials. create new user in "user authentication" . After creation of users you can see the list of users in the left bottom panel. Right click on any user then select "add host from which user can connet" then enter
the IP address of the user system from which you want to access the system.
Please mark this is as "ANSWER"if this helps u out.
All D Best