MYSQL-远程连接错误:Host 'xxxxx' is not allowed to connect to this MySQL server

当前mysql只能允许localhost连接。

只要在localhost的那台电脑,登入mysql后,更改 "mysql" 数据库里的 "user" 表里的 "host" 项,从"localhost"改称"%"

use mysql;

update user set host = '%' where user = 'root';

select host, user from user;

flush privileges;

上一篇:SAXParseException Content is not allowed in Prolog (前言中不允许有内容)


下一篇:openstack环境下搭建的keepalived 两台服务器直接无法ping通VIP ALLOWED-ADDRESS-PAIRS