This forum is no longer active. Please post your questions to our new community site

Error 1130.. Host “Server I.P ” is not allowed to connect to this MySQL server

Subscribe to Error 1130.. Host “Server I.P ” is not allowed to connect to this MySQL server 3 post(s), 2 voice(s)

 
Avatar nikhil09bhise 4 post(s) Is there any solution for it…. Can`t the database in the stack be accessed from outside..? If there is some other way..then I would definitely appreciate your help in this ……
 
Avatar victoria Administrator 134 post(s)

Hi,

For security reasons, we configure MySQL users with access only from your local machine. If you want to access from outside, you will need to give access to your user fisrt. You will need to use the mysql client tool and exute the following:

GRANT ALL ON * TO ’someuser’@’somehost’;
Flush privileges;

where somehost could be a specific IP or % for accessing from any IP.

 
Avatar nikhil09bhise 4 post(s)

OK.. i`ll try it out & will let u know about it…
Thank you for providing this solution……