当前位置: 代码迷 >> 综合 >> ERROR 1129 (HY000): Host ‘192.168.0.1‘ is blocked because of many connection errors; unblock with ‘m
  详细解决方案

ERROR 1129 (HY000): Host ‘192.168.0.1‘ is blocked because of many connection errors; unblock with ‘m

热度:81   发布时间:2023-10-25 19:13:30.0

MySql远程链接报错

问题:

mysql -u root -h 192.168.0.1 -p
Enter password: 
ERROR 1129 (HY000): Host '192.168.0.1' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

解决:在被链接服务器上执行如下

mysqladmin flush-hosts -u root -h192.168.0.1 -p
  相关解决方案