is not allowed to connect to this mysql server

缺乏、安全感 2024-04-19 10:02 99阅读 0赞

# [is not allowed to connect tothis mmysql server][] #

阿里云上安装的mysql，发现用本地电脑的navicat链接不上。通过了解知道了原因，小二在此写了一篇，省的以后自己在碰到。

错误如图。

![format_png][]

mysql -u root -p   登录到mysql中。

[root@izbp10fk8pd9zjv9y2g9ajz etc]# mysql -u root -p
    Enter password:

use mysql;

![20190916233627207.png][]

select host from user where user='root';

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2lpaWlpaWxpa2FuZ3NodWFp_size_16_color_FFFFFF_t_70][]

修改帐号不允许从远程登陆，只能在localhost。这个时候只要在localhost的那台电脑，登入[MySQL][]后，更改 "mysql" 数据库里的 "user" 表里的 "host" 项，从"localhost"改称"%"

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

![20190916233739542.png][]

刷新配置。

flush privileges;

![20190916233802945.png][]

最后如图。链接成功。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2lpaWlpaWxpa2FuZ3NodWFp_size_16_color_FFFFFF_t_70 1][]

[is not allowed to connect tothis mmysql server]: https://www.cnblogs.com/companionspace/p/10316083.html
[format_png]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWcyMDE4LmNuYmxvZ3MuY29tL2Jsb2cvMTU4MTU1My8yMDE5MDEvMTU4MTU1My0yMDE5MDEyNDE3NTczMjQ2NS0xOTc2OTI3NDMyLnBuZw?x-oss-process=image/format,png
[20190916233627207.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/67a840901de5483b93c7d188a9728743.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2lpaWlpaWxpa2FuZ3NodWFp_size_16_color_FFFFFF_t_70]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/ef058b4cc452467ea7de2c39e90f5cc6.png
[MySQL]: http://lib.csdn.net/base/14
[20190916233739542.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/280131c1dbf1446489ac9772da963e96.png
[20190916233802945.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/f74fe41451b24309a69abdb1334d94bf.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2lpaWlpaWxpa2FuZ3NodWFp_size_16_color_FFFFFF_t_70 1]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/c7ce849b666a480aa9ae28a553a0d76a.png