当我运行连接到mysql的python代码时,我看到这个错误:“错误1129:主机''由于许多连接错误而被阻止;请使用'mysqladmin flush-hosts'解除阻止”。
以下是我尝试过的方法: 我增加了max_connection_errors值,并执行了“flush hosts”命令。我还检查了mysql日志,但没有发现问题。此外,我还检查了网络连接,一切正常。
以下是mysql设置:
mysql> SHOW VARIABLES LIKE '%error%';
error_count | 0 log_error | /var/log/mysql/error.log max_connect_errors | 4294967295 max_error_count | 64 slave_skip_errors | OFF
mysql> SHOW VARIABLES LIKE '%max_connections%';
max_connections | 5000
mysql> show status like '%onn%';
Aborted_connects | 6 Connections | 4802 Max_used_connections | 26 Ssl_client_connects | 0 Ssl_connect_renegotiates | 0 Ssl_finished_connects | 0 Threads_connected | 1
mysql>'SHOW STATUS WHERE variable_name LIKE "Threads_%" OR variable_name = "Connections
Connections | 4996 Threads_cached | 7 Threads_connected | 1 Threads_created | 1950 Threads_running | 1
mysql> show processlist;
4800 | root | localhost | NULL | Query | 0 | NULL | show processlist 4807 | root | localhost | db1 | Sleep | 0 | | NULL
请问有人能帮我找出问题所在以及解决方法吗?
以下是我尝试过的方法: 我增加了max_connection_errors值,并执行了“flush hosts”命令。我还检查了mysql日志,但没有发现问题。此外,我还检查了网络连接,一切正常。
以下是mysql设置:
mysql> SHOW VARIABLES LIKE '%error%';
error_count | 0 log_error | /var/log/mysql/error.log max_connect_errors | 4294967295 max_error_count | 64 slave_skip_errors | OFF
mysql> SHOW VARIABLES LIKE '%max_connections%';
max_connections | 5000
mysql> show status like '%onn%';
Aborted_connects | 6 Connections | 4802 Max_used_connections | 26 Ssl_client_connects | 0 Ssl_connect_renegotiates | 0 Ssl_finished_connects | 0 Threads_connected | 1
mysql>'SHOW STATUS WHERE variable_name LIKE "Threads_%" OR variable_name = "Connections
Connections | 4996 Threads_cached | 7 Threads_connected | 1 Threads_created | 1950 Threads_running | 1
mysql> show processlist;
4800 | root | localhost | NULL | Query | 0 | NULL | show processlist 4807 | root | localhost | db1 | Sleep | 0 | | NULL
请问有人能帮我找出问题所在以及解决方法吗?