unauthenticated user in MYSQL process list
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 |
Edit my.cnf file by
root@server [~]# vi /etc/my.cnf
Now add below line as it is
skip-networking
skip-name-resolve
skip-host-cache
skip-locking
skip-host-cache
skip-locking
Once added save it and restart the mysql service and start monitoring the mysql process
Now you will see that the unauthenticated user vanishes within no time
Posts to Review:
How to convert all tables from MyISAM into InnoDB? 
MYSQL Partitioning : What is and HOW To ? ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log Resolved : mysql replica : Relay log read failure: Could not parse relay log event entry.