Host 'xxx.xx.xxx.xxx' is not allowed to connect to this MySQL server

 mysql -u root -p

Enter password: <enter password>
mysql>GRANT ALL ON *.* to root@'123.123.123.123' IDENTIFIED BY 'put-your-password';
mysql>FLUSH PRIVILEGES;
mysql>exit

No comments:

Powered by Blogger.