Error 1130 in mysql

Question

when i am trying to log on mysql using my ip address i am getting error 1130 qht can i do for this

Answer 1

Your client IP is not allowed to connect to this server, you must add it to allowed client account For exemple, assuming you add an user account having all rights in one database :

grant all on db.* to 'username'@'192.168.0.1';

Where db is database name, username the username , and your clients IP is 192.168.0.1

See docs for details of user account creation

Answer 2

On your server run mysql from command line:

mysql -u root -p -h localhost -P 3306 Then run this command in mysql shell:

use mysql

GRANT ALL ON . to root@'%' IDENTIFIED BY 'pass';

FLUSH PRIVILEGES;

Perfect! great steps and resolve the error Failure loading users data from backend [xx.xx.xx.x:3306] for service [Write Failover]. MySQL error 1130, Host

'xx.xx.xx.x' is not allowed to connect to this MariaDB server

Answer 3

On your server run mysql from command line:

mysql -u root -p -h localhost -P 3306

Then run this command in mysql shell:

>use mysql
>GRANT ALL ON *.* to root@'%' IDENTIFIED BY 'yourpassword';
>FLUSH PRIVILEGES;

Have a nice time.