Unauthenticated user in login state on remote MySQL

MySQL is the most popular Open Source Relational SQL Database Management System. MySQL is one of the best RDBMS being used for developing various web-based software applications. MySQL is developed, marketed and supported by MySQL AB, which is a Swedish company.

The MySQL process list indicates the operations currently being performed by the set of threads executing within the server. The SHOW PROCESSLIST statement is one source of process information.

Some time in mysql process list you may see “unauthenticated user” increasing up in local host itself:

| 1004 | unauthenticated user | 192.168.1.1:4455 | NULL | Connect | NULL | login | NULL |

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.

If its remote mysql just edit /etc/hosts and add the ip space hostname of web server

192.168.1.1 server.iserversupport.com

Or

Just Edit my.cnf file  and add the lines

root@server [~]# vi /etc/my.cnf
Now add below line as it is

skip-networking

skip-name-resolve

skip-host-cache

skip-locking

Once added save it and restart the mysql service