Unauthenticated user in login state on remote MySQL

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 |

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

[email protected] [~]# 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 Reply

Your email address will not be published. Required fields are marked *