Pages

Thursday, March 6, 2014

How to Allow MySQL Client to Connect remote MySQL server


You can Allow remote Mysql server from other IP with this script :

$ 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;



No comments:

Post a Comment