且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

未经身份验证的用户在MYSQL中是什么意思?

更新时间:2023-12-01 16:09:52

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

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.

在Pythian博客上获得更多信息.