How to unblock with mysqladmin flush hosts

Question

I have gone through similar cases listed here but it doesn t seem to work   I was using MySQL Workbench to establish a connection with my database which is hosted on another server  Tried a few times and unable to connect followed by this error  I am confused as to where I should even do this flush  On PhpMyadmin under the SQL query  Cos when I tried to input the following command  it returns as syntax error  I am using a windows OS thus no shell shell scripting for me to input this information either  I am accessing the database temporarily via Cpanel  phpmyadmin now     Please help to tell where I should input this data and if my syntax is wrong  Thanks for help    mysqladmin flush-hosts   or  mysqladmin -umyname -pmypassword flush-hosts    My error message as follows       Failed to connect to MYSql at 192     with user myName       Host  host-92     as13285 net  is blocked because of many connection   errors  unblock with   mysqladmin flush-hosts

User · Accepted Answer

mysqladmin is not a SQL statement  It s a little helper utility program you ll find on your MySQL server    and  flush-hosts  is one of the things it can do     status  and  shutdown  are a couple of other things that come to mind    You type that command from a shell prompt   Alternately  from your query browser  such as phpMyAdmin   the SQL statement you re looking for is simply this   FLUSH HOSTS    http   dev mysql com doc refman 5 6 en flush html  http   dev mysql com doc refman 5 6 en mysqladmin html

User · Answer

You can easily restart your MySql service  This kicks the error off

User · Answer

You should put it into command line in windows   mysqladmin -u  username  -p flush-hosts       MySQL password    or  mysqladmin flush-hosts -u  username  -p       MySQL password    For network login use the following command   mysqladmin -h  lt RDS ENDPOINT URL gt  -P  lt PORT gt  -u  lt USER gt  -p flush-hosts mysqladmin -h  YOUR RDS END POINT URL  -P 3306 -u  DB USER  -p flush-hosts    you can permanently solution your problem by editing my ini file Mysql configuration file  change variables max connections   10000   or   login into MySQL using command line -  mysql -u  username  -p       MySQL password    put the below command into MySQL window   SET GLOBAL max connect errors 10000  set global max connections   200    check veritable using command-   show variables like  max connections   show variables like  max connect errors

[mysql] How to unblock with mysqladmin flush hosts

Examples related to mysql

Examples related to mysql-workbench