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

Материал из Wiki - Iphoster - the best ever hosting and support. 2005 - 2023
Версия от 17:11, 29 августа 2019; Admin iph (обсуждение | вклад) (Новая страница: « === MySQL - Host is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' === Ошибка: CDbConnection failed to open the DB con…»)
(разн.) ← Предыдущая | Текущая версия (разн.) | Следующая → (разн.)
Перейти к:навигация, поиск

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

Ошибка:

CDbConnection failed to open the DB connection: SQLSTATE[HY000] [1129] Host 'server.net' is blocked because of many connection errors;
 unblock with 'mysqladmin flush-hosts'


Решение:

# mysqladmin -u da_admin -p flush-hosts
Enter password:


и увеличить в my.cnf:

max_connect_errors=100