mysql connection errors - Linux

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

--