when i am trying to log on mysql using my ip address i am getting error 1130 qht can i do for this
3 Answers
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.
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
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
