Timeline for Host 'host_name' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts'
Current License: CC BY-SA 4.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 28, 2019 at 20:09 | vote | accept | alexus | ||
| Jan 28, 2019 at 15:07 | answer | added | alexus | timeline score: 3 | |
| Jan 28, 2019 at 15:05 | comment | added | alexus |
@eckes unlikely as I even tried following: watch -n 1 'mysqladmin flush-hosts ; echo $?' - which runs mysqladmin flush-hosts every second.
|
|
| Jan 28, 2019 at 15:04 | comment | added | alexus |
@RickJames as I mentioned, I already use that as ~/.my.cnf contains root credentials, which has SUPER privilege.
|
|
| Jan 27, 2019 at 10:15 | comment | added | eckes | Maybe the host gets blocked again right after you flush it? | |
| Jan 27, 2019 at 3:03 | comment | added | Rick James |
You probably need to connect as user "root" or some other SUPER user.
|
|
| Jan 26, 2019 at 20:08 | comment | added | alexus |
@Jay I haven't tried your method, but I assume it'd be exactly the same, as I have ~/.my.cnf (which contains username and password).
|
|
| Jan 26, 2019 at 19:22 | comment | added | Jay Ehsaniara | are you getting same result when you try with: "mysqladmin flush-hosts -u [username] -p" directly from command line ? | |
| Jan 26, 2019 at 19:16 | history | edited | alexus | CC BY-SA 4.0 |
added 538 characters in body
|
| Jan 26, 2019 at 18:59 | history | asked | alexus | CC BY-SA 4.0 |