mysql connection errors - Linux
By Daph Bay
at 2019-07-03T13:08
at 2019-07-03T13:08
Table of Contents
※ 引述《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 (重啟資料庫)
成功了
--
: 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 (重啟資料庫)
成功了
--
Tags:
Linux
All Comments
By Agatha
at 2019-07-04T02:46
at 2019-07-04T02:46
By John
at 2019-07-05T14:04
at 2019-07-05T14:04
By Carol
at 2019-07-10T11:07
at 2019-07-10T11:07
By Robert
at 2019-07-14T08:28
at 2019-07-14T08:28
By Elizabeth
at 2019-07-14T16:47
at 2019-07-14T16:47
By Una
at 2019-07-18T03:57
at 2019-07-18T03:57
By Sierra Rose
at 2019-07-20T18:02
at 2019-07-20T18:02
By Lily
at 2019-07-22T22:41
at 2019-07-22T22:41
Related Posts
根據清單使用mutt寄信
By Leila
at 2019-07-02T12:36
at 2019-07-02T12:36
mysql connection errors
By Suhail Hany
at 2019-07-02T08:53
at 2019-07-02T08:53
為什麼嵌入式系統不流行發行版
By Ina
at 2019-07-02T01:39
at 2019-07-02T01:39
為什麼嵌入式系統不流行發行版
By Eartha
at 2019-07-01T22:10
at 2019-07-01T22:10
ubuntu 18.04 抓不到顯示卡
By Christine
at 2019-06-29T20:12
at 2019-06-29T20:12