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
Leave A Comment