Failed to remote connect to MySQL because of many connection errors;unblock witj ‘mysqladmin flush-hosts’

Problem: My window 10 want to remote connect to Linux MySQL server, but popup with the following error:

This is because the command uses host cache tables to exceed the maximum number of connections for a particular host, MySQL server will not able to make new connections.

Solution: enter Linux server command prompt, enter below command:

mysqladmin flush-hosts

or enter MySQL command prompt, enter below query:

FLUSH HOSTS;

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *

Secured By miniOrange