【MySQL】关于 unauthenticated user的哲学思考

今年双十一遇到一个问题,user里面有unauthenticated user

mysql> show processlist;
+--------+----------------------+----------------------+-----------+---------+-------+-----------------------------+------------------+
| Id     | User                 | Host                 | db        | Command | Time  | State                       | Info             |
+--------+----------------------+----------------------+-----------+---------+-------+-----------------------------+------------------+
|      1 | event_scheduler      | localhost            | NULL      | Daemon  |    25 | Waiting for next activation | NULL             |
| 143573 | d_XXXX_v2            | 10.153.205.173:45272 | d_XXXX_v2 | Sleep   | 23097 |                             | NULL             |
| 143875 | root                 | 10.153.205.173:52192 | d_XXXX_v2 | Sleep   | 22936 |                             | NULL             |
| 156237 | root                 | localhost            | d_XXXX_v2 | Sleep   |  6642 |                             | NULL             |
| 157318 | root                 | localhost            | NULL      | Sleep   |  5791 |                             | NULL             |
| 165517 | d_XXXX_v2            | 10.153.205.173:34345 | d_XXXX_v2 | Sleep   |     3 |                             | NULL             |
| 166163 | root                 | 10.153.205.173:44449 | d_XXXX_v2 | Sleep   |     0 |                             | NULL             |
| 166289 | root                 | localhost            | d_XXXX_v2 | Query   |     0 | init                        | show processlist |
| 167891 | d_XXXX_v2            | 10.153.205.173:59812 | d_XXXX_v2 | Sleep   |     1 |                             | NULL             |
| 168158 | root                 | 10.153.205.173:47288 | d_XXXX_v2 | Sleep   |     0 |                             | NULL             |
| 168159 | unauthenticated user | 10.173.82.76:41376   | NULL      | Connect |  NULL | Reading from net            | NULL             |
+--------+----------------------+----------------------+-----------+---------+-------+-----------------------------+------------------+

http://blog.itpub.net/22664653/viewspace-1815489/

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值