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...*' 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


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

Related questions

Browse Categories