【记录navicat远程连接centos上的数据库，但是报错1130 - Host “192.168,110.139‘ is not allowed to connect to this MySQL】

问题

windows navicat 远程连接centos数据库，报错提示1130 - Host "192.168,110.139’ is not allowed to connect to this MySQL

方案

• 去centos上

mysql -u root -p

use mysql;

select host from user where user = 'root';

如果结果是这个，那么修改这个数据

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

刷新一下

flush privileges;

quit；回车退出

完结撒花🎉🎉🎉