Allow a MySQL Client to Connect to Remote MySQL server

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 be shown message

ERROR 1130: Host is not allowed to connect to this MySQL server

To allow a specific client ip-address to access the mysql database running on a server,   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.10' IDENTIFIED BY 'your-root-password';

where 192.168.1.10 is the address of the client machine