解决-Navicat连接阿里云的MySQL出现“1130-Host 218.3.166.98' is not allowed to connect to this mysQL server”

问题描述

在阿里云的centos上部署了MySQL,而且已经配置了安全规则,但是用navicatMySQL时,出现下图的情况

解决-Navicat连接阿里云的MySQL出现“1130-Host 218.3.166.98' is not allowed to connect to this mysQL server”

 

 解决方法:

1、再次阿里云的配置规则,发现没问题

2、登录centos系统,进行如下操作(一般可以直接复制,除了密码)

mysql -u root -p
use mysql;
解决-Navicat连接阿里云的MySQL出现“1130-Host 218.3.166.98' is not allowed to connect to this mysQL server”
select ‘host‘ from user where user=‘root‘;
解决-Navicat连接阿里云的MySQL出现“1130-Host 218.3.166.98' is not allowed to connect to this mysQL server”
updata user set host=‘%‘ where user=‘root‘;
解决-Navicat连接阿里云的MySQL出现“1130-Host 218.3.166.98' is not allowed to connect to this mysQL server”
flush privileges;
解决-Navicat连接阿里云的MySQL出现“1130-Host 218.3.166.98' is not allowed to connect to this mysQL server”
select ‘host‘ from user where user = ‘root‘;
解决-Navicat连接阿里云的MySQL出现“1130-Host 218.3.166.98' is not allowed to connect to this mysQL server”

 

 

 3、再次连接测试

解决-Navicat连接阿里云的MySQL出现“1130-Host 218.3.166.98' is not allowed to connect to this mysQL server”

 

解决-Navicat连接阿里云的MySQL出现“1130-Host 218.3.166.98' is not allowed to connect to this mysQL server”

上一篇:mongodb


下一篇:【Win10 应用开发】集成文件打开选择器