☰

mysql 登录失败

tag-icon • tag-icon authentication linux mysql
mysql 登录失败

我遇到一个问题，有人/某物试图在没有用户/密码的情况下连接到我的数据库。3306 上的端口转发未激活。我的 SQL 错误日志：

2019-02-06T15:32:32.888533+01:00 11141 [Note] Access denied for user ''@'localhost' (using password: NO)
2019-02-06T15:34:32.908937+01:00 11168 [Note] Access denied for user ''@'localhost' (using password: NO)
2019-02-06T15:36:32.931560+01:00 11196 [Note] Access denied for user ''@'localhost' (using password: NO)
2019-02-06T15:38:32.952347+01:00 11224 [Note] Access denied for user ''@'localhost' (using password: NO)
2019-02-06T15:40:32.973641+01:00 11250 [Note] Access denied for user ''@'localhost' (using password: NO)
2019-02-06T15:42:32.994320+01:00 11277 [Note] Access denied for user ''@'localhost' (using password: NO)

我如何才能找出哪个守护进程/程序/文件正在尝试连接？谢谢！

答案1

如果有人感兴趣的话：这是我的 Monit 配置中的这一行：

if failed unixsocket /var/run/mysqld/mysqld.sock protocol mysql for 3 times within 4 cycles then restart

删除此行后，问题就消失了。

相关内容