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

Share on Google Plus

About Md. Shahzad Alam

I am a passionate cloud and DevOps professional specializing in Linux and open-source solutions. Through this blog, I share my knowledge and experience with the community, offering tips and insights on cloud technologies and DevOps practices.