MySQL unauthenticated user
mysql
Solution
Ok, Here is the issue and how to resolve it.. it took me a month and i've been looking all over
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.
Most often stuck connections are due to DNS not resolving properly, which the skip-name-resolve option will help with.
More info at the Pythian blog.
use skip-name-resolve in my.cf and that should resolve your problem.
Problem
Problem MySQL is showing many unauthenticated users. Set up Load Balance server that points to 5 webservers All connected to 1 database/files server. Info It seems only requests from servers 1 and 2 are having the unauthenticated user problem. Servers 3,4 & 5 are working fine but looks like their users are staying in the process list. Is there any reason why only 2 of the servers would be acting up? ``` +--------+------------------- --+----------------------+----------+-----------+------+---------+------+ | Id | User | Host | db | Command | Time | State | Info | +--------+----------------------+----------------------+----------+-----------+------+---------+------+ | 171733 | unauthenticated user | web.1.IP.HERE:50038 | NULL | Connect | NULL | login | NULL | | 171735 | unauthenticated user | web.1.IP.HERE:50039 | NULL | Connect | NULL | login | NULL | | 171736 | unauthenticated user | web.1.IP.HERE:60721 | NULL | Connect | NULL | login | NULL | | 171737 | unauthenticated user | web.2.IP.HERE:50040 | NULL | Connect | NULL | login | NULL | | 171746 | unauthenticated user | web.2.IP.HERE:60723 | NULL | Connect | NULL | login | NULL | | 181337 | username | web.3.IP.HERE:34426 | dbName | Sleep | 4 | | NULL | | 181339 | username | web.3.IP.HERE:51668 | dbName | Sleep | 4 | | NULL | | 181340 | username | web.4.IP.HERE:51669 | dbName | Sleep | 4 | | NULL | +--------+----------------------+----------------------+----------+-----------+------+---------+------+ ``` I have seen the mention of `skip-name-resolve` but when I run `select user, host FROM mysql.user` I only see IPS or "localhost" in the host column so i dont see how that would fix it. Overall the processlist still seems high with other users as well but under "info" it says NULL. Anyway to clear these?