3
4

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 5 years have passed since last update.

MySQL で接続エラー

Posted at

mysqld が途中で中断された多数の接続要求を特定のホストから受け取ったとき、

Error: Host '' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

接続が成功せずに「max_connect_errors」の回数要求が失敗するとこのエラーが表示される。
まず、<接続失敗の原因を解明、解決をした後>に

flush hosts;

でエラーをクリア。

set global max_connect_errors=エラー数;

で許容接続エラーのMaxを変更する(※エラー数は例えば「10000」等)

show global variables like '%connect%';

で確認。

3
4
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
3
4

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?