Tuesday, May 27, 2008

Enabling MySQL log_warnings variable

I'm encountering a MySQL connection error [host "ip-address" is blocked because of too many connection errors. Unblock with 'mysqladmin flush-host"] whenever I use my MySQL Tools to connect to our MySQL server, what the error means is that I'm having too many connection error and MySQL is now blocking any incoming connection. I had in my MySQL server configuration set the "max_connect_error" variable set to 10 and don't want to increase it but I would want to know what account is trying to connect and failed, by default the "log_warnings" variable is set to "OFF" in order to turn it "ON" you have to login to mysql and invoke the "set global" command like so:

0 comments:

Post a Comment