SQLSTATE[HY000] [1129] Host '0.0.0.0' is blocked because of many connection errors

HI. I updated Laravel to 5.6 from 5.5 yesterday and since doing so ive been getting this error

SQLSTATE[HY000] [1129] Host 'my.ip.add.ress' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts' (SQL: select * from `sessions` where `id` = ApVsDfv8IrfIiAxFthvdZnqcpSKuslyISKjqGvpa limit 1)

Its only happening on localhost (vagrant) and not in production on DO server

How do i check how many connections are being used or how would i go about fixing this error?

Cheers

tomopongrac

8 years ago

Level 51

Did you check mysql documentation

https://dev.mysql.com/doc/refman/5.7/en/blocked-host.html

skoobi

8 years ago

Level 13

Hi @tomopongrac . Ye checked the docs but it was strange why i could flush the hosts using sudo mysqladmin flush-hosts on the DO server and its all ok but by the morning it was back the same again.

I think i managed to find the cause but ill see in the morning if it was or not.

After upgrading Laravel to 5.6 i also added a cron to vagrant, so my thoughts are its something squawking when the cron runs. And since it runs every minute there will be a few errors id imagine if something isn't right.

Thanks

Please or to participate in this conversation.