Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
in SQL by (5k points)

I applied so many solutions to it, but none of it seems to be working. 

I tried using MySQL Workbench to make a connection with my database which is hosted on a different server. But this is giving me an error. 

mysqladmin flush-hosts; or mysqladmin -umyname -pmypassword flush-hosts;

This is my error:

Failed to connect to MYSql at 192...* with user myName

Host 'host-92...*.as13285.net' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

1 Answer

0 votes
by (10.2k points)
edited by

The mysqladmin is not at all a SQL statement. It is just a basic program to help your MySQL server. Also, it can achieve "flush-hosts". 

You can use a shell prompt to update that command.

Therefore from your query browser like phpMyAdmin, the SQL statement that you need is just

FLUSH HOSTS;

If you want to get more insights into SQL, check out this SQL Course from Intellipaat.

Related questions

Browse Categories

...