MySQL meets & quot; unauthenticateduser & quot; do not panic _ MySQL

MySQL encountered amp; quot; unauthenticateduseramp; quot; do not panic from yesterday, I began to monitor MySQL, and found that from time to time will appear

It is strange that in the MySQL configuration file, the configuration prohibits domain name resolution -- skip-name-resolve. for details, see how mysql uses dns, this is a bug in MySQL, but my database version is not listed in it. This article has stabilized my mind.

"Unauthenticated user"Means a connection initiated by a client, but the client user has not been authenticated yet. This problem occurs when the system load is high or mysql is busy.

In addition, there are several User users in the show processlist file, which is common.

1.System user

It refers to the user who handles internal tasks distributed by the service without a client thread. It is usually used by the slave I/O thread or SQL thread in the master-slave database. The system user has an obvious sign that the Host column has no content.

2.Event_scheduler

It refers to the user used by the monitor event thread.

References:

Show-processlist