未经身份验证的用户在MYSQL中是什么意思? [英] what does unauthenticated user mean in 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)
推荐答案
用户"列中与未经身份验证的用户"的连接已启动连接，但尚未发送其凭据，因此服务器不知道到底是谁在连接.
A connection with "unauthenticated user" in the User column has initiated a connection but hasn't sent his/her credentials yet, so the server doesn't know who exactly is connecting.
如果此类连接仅在通过身份验证时才出现在列表中，则可能会导致服务器用尽可用的套接字，并且您甚至都不知道为什么.
If such connections only showed up in the list when they were authenticated, it could potentially run the server out of available sockets and you wouldn't even know why.
大多数卡死的连接是由于 DNS无法正确解析，请使用skip-name-resolve选项可以解决此问题.
Most often stuck connections are due to DNS not resolving properly, which the skip-name-resolve option will help with.
这篇关于未经身份验证的用户在MYSQL中是什么意思?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
