unable to login

[saggi_sam]

hi,

i am tryting to connect with Mysql which is installed on remote server by sqlyog which is on my local machine. I am using 'sqlyog 3.11'. The error which comes when i try to connect is as following.

“Error No. 1129. Host 'i-p address' is blocked because of too many connection errors. Unblock with 'mysqladmin flush-host”

As per the message something has to be flushed on Server. But how….i donot know as i am new to mysql.

Pls. help.

[Ritesh]

The following links might help:

http://dev.mysql.com/doc/mysql/en/Blocked_host.html

http://dev.mysql.com/doc/mysql/en/Too_many…onnections.html

[Shadow]

There must be (or must have been) some network connection problem between you and the machine running MySql server and MySql locked your machine out. FLUSH HOSTS command will reset the error counter and will let your machine connect in case of no further errors.

[saggi_sam]

thnks…a ton….ritesh/shadow…

it has worked…..

http://dev.mysql.com/doc/mysql/en/Blocked_host.html

was great and 'flush hosts' has done the job.

But i would like to know that is there any difference between

'mysqladmin flush-host'

and

'flush hosts'

commands. These two commands were written in the above given link. i have used 'flush hosts'

[Shadow]

mysqladmin is a command line tool that can be run with different parameters, while FLUSH HOSTS is a MySql specific SQL command (at least sort of…). Both do the same thing.

[Author]

Posts