解释mysql查询日志

Question

具有以下功能：

select * from mysql.general_log order by event_time desc

为什么它经常显示“访问被拒绝”？它似乎每隔两秒左右就会尝试这样做。这是一个bug吗?或者为什么会发生这种情况?这意味着什么？

| user_host                 | thread_id | server_id | command_type | argument                                                          |
+---------------------------+-----------+-----------+--------------+-------------------------------------------------------------------+
| root[root] @ localhost [] |       122 |         0 | Query        | select * from mysql.general_log order by event_time desc          |
| [] @ localhost []         |       223 |         0 | Connect      | Access denied for user 'dave'@'localhost' (using password: NO) |
| [dave] @ localhost []  |       223 |         0 | Connect      | dave@localhost as  on                                          |
| [] @ localhost []         |       222 |         0 | Connect      | Access denied for user 'dave'@'localhost' (using password: NO) |
| [dave] @ localhost []  |       222 |         0 | Connect      | dave@localhost as  on                                          |
| [] @ localhost []         |       221 |         0 | Connect      | Access denied for user 'dave'@'localhost' (using password: NO) |
| [dave] @ localhost []  |       221 |         0 | Connect      | dave@localhost as  on                                          |
| [] @ localhost []         |       220 |         0 | Connect      | Access denied for user 'dave'@'localhost' (using password: NO) |
| [dave] @ localhost []  |       220 |         0 | Connect      | dave@localhost as  on                                          |
| [] @ localhost []         |       219 |         0 | Connect      | Access denied for user 'dave'@'localhost' (using password: NO) |
| [dave] @ localhost []  |       219 |         0 | Connect      | dave@localhost as  on                                          |
| [] @ localhost []         |       218 |         0 | Connect      | Access denied for user 'dave'@'localhost' (using password: NO) |
| [dave] @ localhost []  |       218 |         0 | Connect      | dave@localhost as  on                                          |
| [] @ localhost []         |       217 |         0 | Connect      | Access denied for user 'dave'@'localhost' (using password: NO) |
| [dave] @ localhost []  |       217 |         0 | Connect      | dave@localhost as  on                                          |
| [] @ localhost []         |       216 |         0 | Connect      | Access denied for user 'dave'@'localhost' (using password: NO) |
| [dave] @ localhost []  |       216 |         0 | Connect      | dave@localhost as  on                                          |
| [] @ localhost []         |       215 |         0 | Connect      | Access denied for user 'dave'@'localhost' (using password: NO) |

Answer 1

正如错误消息所示，有人试图以dave的身份从您的本地计算机连接到您的服务器，而不使用密码。我假设dave帐户要么不存在，要么存在，但限制在IP上，要么使用密码存在。

如果是复制，你不会看到'dave'@'localhost'被拒绝访问，它应该是'dave'@'someotherserver' (除非你有两个mysql进程在同一台服务器上运行)。

如果这是正常的事情，那么我会首先查看cron；看看是否有任何东西正在定期尝试连接到MySQL。