Friday 15 August 2014
How to Allow MySQL Client to Connect to Remote MySQL server
Issue: How do I allow a MySQL client to connect to a MySQL database server?
Solution: By default, MySQL does not allow remote clients to connect to the MySQL database.
If you try to connect to a remote MySQL database from your client system, you will get the “Host is not allowed to connect to this MySQL server” message as shown below.
$ mysql -h 192.168.1.8 -u root -p
Enter password:
ERROR 1130: Host '192.168.1.4' is not allowed to connect to this MySQL server
You can also validate this by doing telnet to 3306 mysql port as shown below, which will also give the same “host is not allowed to connect to this MySQL server” error message.
$ telnet 192.168.1.8 3306
host 192.168.1.4 is not allowed to connect to this mysql server
If you want to allow a specific client ip-address (for example: 192.168.1.4) to access the MySQL database running on a server, you should execute the following command on the server that is running the MySQL database.
$ 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;
Also, update firewall rules to make sure port# 3306 is open on the server that is running the MySQL database.
After the above changes, when you try to connect to the MySQL database from a remote client, you’ll not get the “Host is not allowed to connect to this MySQL server” error message any more.
Subscribe to:
Post Comments (Atom)
Mastering Docker Minified Systems: A Step-by-Step Guide with Real Use Cases
Introduction Docker is a powerful platform for developing, shipping, and running applications. Minified Docker systems are optimized for siz...
-
How To Hide and unhide the hard disk Volumes using CMD Commands : First check how many drives are there in my computer and then s...
-
Issue: You go to activate Microsoft Office 2010 and you receive a message stating, “Your copy of Microsoft Office Professional Plus 2010 ca...
-
VMWare Workstation doesn't ship in a deb, so it isn't registered in dpkg (which is why you can't find it in the software center...
No comments:
Post a Comment