How to "unblock with mysqladmin flush-hosts "

Hello,

I have tried several times to log in on my host-server, now I've got a pop-up with the text "Host '4-177-ftth.onsbrabantnet.nl'is blocked because of to many connection errors; unblock with mysqladmin flush-hosts'. I really don't know how tot do that, can someone explain to me please.
Thanks, Martin.

you have to have shell acces to your host, or know someone who does. you then connect to the host, usually using ssh, and on its shell command line type in the command mysqladmin -u username -ppasswd flush-hosts. this do it.

PS: your host name looks as if you are on a hosting provider's shared host. if so, and if you do not have shell access with your account, you will have to contact your hosting providers' support and tell them to unlock your mysql account.

Thanks, I will contact my providers help desk and send them your advise.

My provider answered me :"I'm sorry, dit is SSH and this is only possible with own VPS and not with a shared hosting". So, this means I think that I shall look to an alternative program instead of HeidiSQL, and that is pity because the program is great.
Do you see an alternative way to unblock??
Thanks.

please tell your provider only "please unlock my mysql account - have entered wrong password too many times", nothing more, except your account identification. they should really be able to do that regardless of ssh, vps or other strange acronyms; you are not the only person on earth who ever had accidentally locked his database account.

also "I shall look to an alternative program instead of HeidiSQL" you are welcome to do that, but currently no other program (eg mysqlyog) will unlock your account, either. this is because it is uninteresting what sort of client you are using when you generally do not have client access to your mysql server any more; this can be remedied only on the server side.

unfortunately a part of what i just wrote is wrong because i did not read your first post again. so, please tell them that you got the error message you mentioned in your first post ("Host '4-177-ftth.onsbrabantnet.nl' is blocked .. mysqladmin flush-hosts") and that they should unblock it, they should know how to do that.

Thank you; do you mean that they should unblock by unlocking my mysql account?
Actualy I do have access to my database, just have to use phpMyAdmin on the server of the provider (direct log-in). But when I use HeidiSQL then I receive this blocked-message. For instance, using a tool like PHPMaker to approach the database is no problem.
Is this info helpfull for you?

"do you mean that they should unblock by unlocking my mysql account?" they should unblock your access to the dabtbase from a remote client, period. since blocking hosts or clients is not a standard feature of a mysql server, it has to be caused somehow by your provider (ie by an automatic process (firewall?) installed by them); if they can block it, they should be able to unblock it as well upon customer request (ie you).

blocking appears to be specific to your client's ip address - eg if you attempt to access the database from heidisql (remote client) access is blocked; if from phpMyAdmin (server-based, most probably on same server or subnet as database) or PHPMaker (server-based, different ip address) it is not blocked.

Thank you, I past your answer to my provider. Just have to wait if he is able to unblock :-)
I'll keep you posted.

Hey I was doing online shopping suddenly this error appear, Could any one help me how to unlock this?

@Mystic M

Connect to your mysql-server and type in FLUSH HOSTS.