use mysql;
select host, user from user; // 查看host是否是‘%’
// 如果不是
update user set host='%' where user='root'; // 有报错,不予理会
flush privileges;
ERROR 1130 (HY000): Host 'xxx.xxx.xx.xx' is not allowed to connect to this MySQL(MariaDB) server
最新推荐文章于 2024-07-29 14:57:24 发布