HowTo Enable remote connection: host not allowed to connect mySql server
If you happened to face the error mentioned above, it’s most probable that mySql connection is not configured to allow remote connection. If that is the case, or if you have not done the steps below, you could try out if below commands would resolve the issue by going to mysql command prompt:
$ mysql -u root -p
Enter password:
mysql> use mysql
mysql> GRANT ALL ON *.* to root@’192.168.1.4′ IDENTIFIED BY ‘your-root-password’;
mysql> FLUSH PRIVILEGES;
Try to connect back to the mySql server from the client.
Written by admin on October 14th, 2011 with no comments.
Read more articles on Entertainment.
