unauthenticated user in MYSQL process list

[euk_Vincent]

Some time in mysql process list you may see "unauthenticated user" increasing up it look like:

| 1004 | unauthenticated user | xxx.xxx.xxx.xxx:4455 | NULL | Connect | NULL | login | NULL |

Now to halt such users accessing mysql follow below steps:

Edit my.cnf file by

[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 and start monitoring the mysql process throgh below command:

mysqladmin pr -i3

Now you will see that the unauthenticated user vanishes within no time..