Mysql无法连接[MySql Host is blocked because of many connection errors]

posted | in | visitors: |
| wordcount: 95 | min2read ≈ 1
mysql 出现[MySql Host is blocked because of many connection errors]的错误

  • 测试环境，发现数据库（MySQL数据库）无法登录，报错如下：

    Host is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’

  • 解决方案：使用mysqladmin flush-hosts 命令清理一下hosts文件（不知道mysqladmin在哪个目录下可以使用命令查找：whereis mysqladmin）；

  • 登录到MySQL数据库中，mysql -uroot -h host -p

  • 执行

    1
    mysqladmin flush-hosts

    问题解决。

-------------The End-------------

Title:Mysql无法连接[MySql Host is blocked because of many connection errors]

Author:cloud sjhan

Publish Time:2018年09月01日 - 13:09

Last Update:2018年09月01日 - 13:09

Original Link:https://cloudsjhan.github.io/2018/09/01/Mysql无法连接/

License: By-NC-ND 4.0 international。

cloud sjhan wechat
subscribe to my blog by scanning my public wechat account
keep going, keep coding
0%
;