Question

当我试图用我自己的地址在我sql上记录时,一度错过1130 qht,就可以这样做。

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 ;

如果db为数据库名称,用户名称和客户IP为192.168。

See 。用户账户制作细节

Answer 2

在你的服务器上,从指挥线上运行了我的舱面:

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

之后,我方车上指挥了这一指挥:

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

时间为零。

Answer 3

在你的服务器上,从指挥线上运行了我的舱面:

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

使用我方

∗∗∗∗∗

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

页: 1 亚洲开发银行服务器

友情链接