1130 - Host '112.65.1.181' is not allowed to connect to this MySQL server

mysql版本 mysql7

 

use mysql;
update user set host = '%' where user = 'root';
select host, user from user;
刷新数据库 flush privileges;
退出: quit;
重启mysql service mysqld restart

posted @ 2020-07-24 14:46  敬芝  阅读(139)  评论(0编辑  收藏  举报