※ 引述《jeffher1024 (小何)》之铭言:
: Dear All,
: 最近WEB后台发生数据库错误如下,要如何彻底解决这个问题呢?
: SQLSTATE[HY000] [1129] Host '192.168.1.254' is blocked because of many
: connection errors; unblock with 'mysqladmin flush-hosts'
: Filename: controllers/sysAdmin/Main.php
: Line Number: 132
: Benson
改/etc/my.cnf.d/server.cnf
[mysqld]
max_connections=1000 #benson
max_connect_errors=1000 #benson
改完 systemctl restart mysql (重启数据库)
成功了