1130 - Host ‘10.0.0.1‘ is not allowed to connect to this MySQL server
1130 - Host '10.0.0.1' is not allowed to connect to this MySQL server
一、1130 - Host ‘10.0.0.1’ is not allowed to connect to this MySQL server
mysql -u root -p #连接服务登录mysql
show databases; #查看当前所有数据库
use mysql; #进入mysql数据库
show tables; #查看mysql数据库中所有的表
select Host, User from user; #查看user表中的数据
update user set Host='%' where User='root'; #修改user表中的Host
flush privileges; #最后刷新一下
二、1130 - Host ‘10.0.0.1’ is not allowed to connect to this MariaDB server
#首先进入 mysql 数据库中
grant all privileges on *.* to 'root'@'%' with grant option;
flush privileges;
exit;
endl
原文地址：https://blog.csdn.net/qq_45740503/article/details/143662247
免责声明：本站文章内容转载自网络资源，如本站内容侵犯了原著者的合法权益，可联系本站删除。更多内容请关注自学内容网（zxcms.com）！