Search This Blog

Total Pageviews

Sunday 4 December 2011

How to fix mysqladmin ( in Mysql) flush-hosts issue ?

mysql
mysql mysqladmin flush-hosts


SQLSTATE[HY000] [1129] Host 'xxx-01.XXXX.co.uk' is blocked because of many connection errors;
unblock with 'mysqladmin flush-hosts' in lock_may_be_available() (line 164 of /XXXX/www/drupal-7.7/includes/lock.inc).


/XXXXX/www/drupal-7.7/includes/lock.inc


[root@ ~]# mysqladmin -uroot -p flush-hosts
Enter password:

or

[root@ ~]# mysqladmin -uroot -pxxxx flush-hosts

Oracle DBA

anuj blog Archive