Announcement

Collapse
No announcement yet.

unauthenticated user in MYSQL process list

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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 |


    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..
Working...
X