Mysql flush-hosts
unblock with ‚mysqladmin flush-hosts
-
LinkBack
-
Thread Tools
-
Display
03-05-2013, 17:55 #1
Forum Member
- Join Date
- Mar 2011
- Posts
- 54
unblock with ‚mysqladmin flush-hosts
While connecting to the database via mysqlclient or phpmyadmin we some time might get below error saying:
unblock with ‚mysqladmin flush-hostsNow to solve the above issue, you can perform nay of the below steps:
1] Simple way is to retstart the mysql service by below command:
/etc/init.d/mysql restart2] Edit the my.cnf file and increase the below parameter and restart the mysql service:
vi /etc/my.cnf
max_connections=10000
/etc/init.d/mysql restart3] Fire below command by loging to the server via ssh:
mysqladmin -uroot -ppassword flush-hosts;