Hydra**mysql常见的两个错误
文章目录
无法连接到mysql服务
[ERROR] Host ‘192.168.83.157’ is not allowed to connect to this MySQL server
这是因为没有开启msyql远程服务。
登录mysql:
mysql -u root -p 密码
开启mysql远程访问:
use mysql;
update user set host = ‘%’ where user = ‘root’; 这一句执行完可能会报错,不用管它。
FLUSH PRIVILEGES; 清空被锁死的主机
太多次连接
[ERROR] Host ‘192.168.83.157’ is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts’
这是因为同一ip在短时间内产生太多次连接,我们可以增加允许同时连接的数量:
show global variables like ‘%max_connect_errors%’;
set global max_connect_errors=10000;