阿里云上安装的mysql，发现用本地电脑的navicat链接不上。
微信图片_20200404163059.png
解决办法如下
mysql -u root -p 登录到mysql中。
[root@izbp10fk8pd9zjv9y2g9ajz etc]# mysql -u root -p
Enter password:
use mysql;
select host from user where user='root';
修改帐号不允许从远程登陆，只能在localhost。这个时候只要在localhost的那台电脑，登入MySQL后，更改 "mysql" 数据库里的 "user" 表里的 "host" 项，从"localhost"改称"%"
update user set host = '%' where user ='root';
刷新配置。
flush privileges;
然后在本地重新连接！success！
阿里云上安装的mysql，发现用本地电脑的navicat链接不上。 解决办法如下 mysql -u root -p...
”according to the law，you are not being allowed marry thi...
报"Host ‘169.254.213.3’ is not allowed to connect to this ...
Host 'XXX' is not allowed to connect to this MySQL server...
报错:1130-host ... is not allowed to connect to this MySql ...
mysql远程连接 Host * is not allowed to connect to this MySQL ...
错误：1130 - Host 'xxxx' is not allowed to connect to this M...
错误1 1130 - Host XXX is not allowed to connect to this MyS...
远程连接提示：Host 'xxx' is not allowed to connect to this MySQL...
1. 安装 Host is not allowed to connect to this MySQL server...
本文标题：is not allowed to connect to thi
本文链接：https://www.haomeiwen.com/subject/cfmjphtx.html
网友评论