※ 引述《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 (重啟資料庫)
成功了