mysql 无身份验证_未经身份验证的用户在MYSQL中意味着什么?

mysql> show full processlist;

+-----+----------------------+--------------------+------+---------+------+----------------------------------+-----------------------+

| Id | User | Host | db | Command | Time | State | Info |

+-----+----------------------+--------------------+------+---------+------+----------------------------------+-----------------------+

| 1 | system user | | NULL | Connect | 623 | Waiting for master to send event | NULL |

| 2 | system user | | NULL | Connect | 0 | Reading event from the relay log | NULL |

| 400 | root | localhost | v3 | Sleep | 68 | | NULL |

| 585 | root | localhost | v3 | Query | 0 | NULL | show full processlist |

| 748 | unauthenticated user | 172.19.0.27:32833 | NULL | Connect | NULL | login | NULL |

| 749 | unauthenticated user | 172.19.0.27:32836 | NULL | Connect | NULL | login | NULL |

| 750 | unauthenticated user | 172.19.0.27:32838 | NULL | Connect | NULL | login | NULL |

| 751 | unauthenticated user | 172.19.0.27:32841 | NULL | Connect | NULL | login | NULL |

| 752 | unauthenticated user | 172.19.0.27:32844 | NULL | Connect | NULL | login | NULL |

| 753 | unauthenticated user | 172.19.0.27:32846 | NULL | Connect | NULL | login | NULL |

| 754 | unauthenticated user | 172.19.0.27:32848 | NULL | Connect | NULL | login | NULL |

| 755 | unauthenticated user | 172.19.0.139:46827 | NULL | Connect | NULL | login | NULL |

| 756 | unauthenticated user | 172.19.0.139:46830 | NULL | Connect | NULL | login | NULL |

| 757 | unauthenticated user | 172.19.0.139:46831 | NULL | Connect | NULL | login | NULL |

| 758 | unauthenticated user | 172.19.0.27:32857 | NULL | Connect | NULL | login | NULL |

| 759 | unauthenticated user | 172.19.0.27:32858 | NULL | Connect | NULL | login | NULL |

| 760 | unauthenticated user | 172.19.0.27:32859 | NULL | Connect | NULL | login | NULL |

| 761 | unauthenticated user | 172.19.0.27:32863 | NULL | Connect | NULL | login | NULL |

| 762 | unauthenticated user | 172.19.0.27:32864 | NULL | Connect | NULL | login | NULL |

| 763 | unauthenticated user | 172.19.0.27:32866 | NULL | Connect | NULL | login | NULL |

| 764 | unauthenticated user | 172.19.0.27:32870 | NULL | Connect | NULL | login | NULL |

| 765 | unauthenticated user | 172.19.0.27:32871 | NULL | Connect | NULL | login | NULL |

| 766 | unauthenticated user | 172.19.0.139:46833 | NULL | Connect | NULL | login | NULL |

| 767 | unauthenticated user | 172.19.0.27:32878 | NULL | Connect | NULL | login | NULL |

| 768 | unauthenticated user | 172.19.0.27:32881 | NULL | Connect | NULL | login | NULL |

| 769 | unauthenticated user | 172.19.0.27:32885 | NULL | Connect | NULL | login | NULL |

| 770 | unauthenticated user | 172.19.0.139:46835 | NULL | Connect | NULL | login | NULL |

| 771 | unauthenticated user | 172.19.0.27:32888 | NULL | Connect | NULL | login | NULL |

| 772 | unauthenticated user | 172.19.0.27:32890 | NULL | Connect | NULL | login | NULL |

| 773 | unauthenticated user | 172.19.0.139:46837 | NULL | Connect | NULL | login | NULL |

| 774 | unauthenticated user | 172.19.0.139:46839 | NULL | Connect | NULL | login | NULL |

| 775 | unauthenticated user | 172.19.0.139:46841 | NULL | Connect | NULL | login | NULL |

| 776 | unauthenticated user | 172.19.0.139:46844 | NULL | Connect | NULL | login | NULL |

| 777 | unauthenticated user | 172.19.0.139:46845 | NULL | Connect | NULL | login | NULL |

| 778 | unauthenticated user | 172.19.0.139:46847 | NULL | Connect | NULL | login | NULL |

| 779 | unauthenticated user | 172.19.0.27:32898 | NULL | Connect | NULL | login | NULL |

| 780 | unauthenticated user | 172.19.0.27:32900 | NULL | Connect | NULL | login | NULL |

| 781 | unauthenticated user | 172.19.0.139:46850 | NULL | Connect | NULL | login | NULL |

| 782 | unauthenticated user | 172.19.0.139:46852 | NULL | Connect | NULL | login | NULL |

| 783 | unauthenticated user | 172.19.0.139:46854 | NULL | Connect | NULL | login | NULL |

| 784 | unauthenticated user | 172.19.0.139:46857 | NULL | Connect | NULL | login | NULL |

| 785 | unauthenticated user | 172.19.0.139:46859 | NULL | Connect | NULL | login | NULL |

| 786 | unauthenticated user | 172.19.0.27:32903 | NULL | Connect | NULL | login | NULL |

| 787 | unauthenticated user | 172.19.0.139:46862 | NULL | Connect | NULL | login | NULL |

| 788 | unauthenticated user | 172.19.0.139:46865 | NULL | Connect | NULL | login | NULL |

| 789 | unauthenticated user | 172.19.0.139:46866 | NULL | Connect | NULL | login | NULL |

| 790 | unauthenticated user | 172.19.0.139:46868 | NULL | Connect | NULL | login | NULL |

| 791 | unauthenticated user | 172.19.0.139:46871 | NULL | Connect | NULL | login | NULL |

| 792 | unauthenticated user | 172.19.0.139:46873 | NULL | Connect | NULL | login | NULL |

| 793 | unauthenticated user | 172.19.0.27:32907 | NULL | Connect | NULL | login | NULL |

| 794 | unauthenticated user | 172.19.0.27:32909 | NULL | Connect | NULL | login | NULL |

| 795 | unauthenticated user | 172.19.0.27:32911 | NULL | Connect | NULL | login | NULL |

| 796 | unauthenticated user | 172.19.0.139:46875 | NULL | Connect | NULL | login | NULL |

| 797 | unauthenticated user | 172.19.0.27:32914 | NULL | Connect | NULL | login | NULL |

| 798 | unauthenticated user | 172.19.0.27:32916 | NULL | Connect | NULL | login | NULL |

| 799 | unauthenticated user | 172.19.0.139:46877 | NULL | Connect | NULL | login | NULL |

| 800 | unauthenticated user | 172.19.0.139:46879 | NULL | Connect | NULL | login | NULL |

+-----+----------------------+--------------------+------+---------+------+----------------------------------+-----------------------+

57 rows in set (0.00 sec)

与“用户”列中的“未经身份验证的用户”的连接已启动连接,但尚未发送其凭据,因此服务器不知道正在连接的用户.

如果这样的连接只有在通过身份验证时才会在列表中显示出来,那么可能会将服务器从可用套接字中运行,甚至不知道为什么.

More info在Pythian博客.

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

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

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

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值