Comment posted Fix MySQL connection error – Host ” is blocked because of many connection errors; unblock with ‘mysqladmin flush-hosts’ by .
Recent comments by
If you're new here, you may want to subscribe to my RSS feed. Thanks for visiting!
Hey long time now see, thanks for dropping back again! 🙂
Previoust Post:
Next Post:
Tags: application, cnf, config, connection, connection timeout, default, fix, issue, lot, mysqladmin, programming language, reason, setting, size, suggestion, system
This entry was posted
on Wednesday, April 24th, 2024 at 2:29 am and is filed under Everyday Life, MySQL, System Administration, Various.
You can follow any responses to this entry through the RSS 2.0 feed.
Both comments and pings are currently closed.
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; en) Opera 8.50
İyi paylaşım devamını beklerim
View CommentView CommentMozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.2743.82 Safari/537.36
Hi,
Can you tell me where does mysql stores the current count of connection errors? I know total allowed errors is saved in max_connect_errors, I want to know current count of connection errors to check anyone is trying to connect with wrong password or not.
View CommentView CommentMozilla/5.0 (Macintosh; Intel Mac OS X 10_8_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.102 Safari/537.36 OPR/37.0.2178.54
Play with show connections; un mysql cli
try
help show;
and check the arguments.
Regards,
Georgi
View CommentView Comment