ERROR 1130 (HY000): Host 'x.x.x.x' is not allowed to connect to this MySQL server

Error:
ERROR 1130 (HY000): Host 'x.x.x.x' is not allowed to connect to this MySQL server

I got the above error when i was accessing the mysql database server from my remote machine.
I have done the folling changes on mysql database server and my problem got resolved.

Solutions:

CREATE USER 'username'@'remote_machine_ip' IDENTIFIED BY 'Qait@12345';
GRANT ALL PRIVILEGES ON dbname.* TO 'username'@'remote_machine_ip';

Try now:
mysql -u username -p -h mysql_db_ip



Post a Comment

Mới hơn Cũ hơn