# MySQL Flooded by "unauthenticated user"

**URL:** https://forums.percona.com/t/mysql-flooded-by-unauthenticated-user/6337
**Category:** Other MySQL® Questions
**Created:** [May 5, 2018, 5:02am UTC](https://forums.percona.com/t/mysql-flooded-by-unauthenticated-user/6337 "2018-05-05T05:02:06Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Jardenblack26](https://avatars.discourse-cdn.com/v4/letter/j/8baadc/32.png) [@Jardenblack26](https://forums.percona.com/u/Jardenblack26)
#### Post date: [May 5, 2018, 5:02am UTC](https://forums.percona.com/t/mysql-flooded-by-unauthenticated-user/6337/1 "2018-05-05T05:02:06Z")

</div>

Hi Gurus,

My MySQL server was very busy. After checking, I found many unauthenticated user connections when running “show full processlist”:

| 2018434580 | unauthenticated user | connecting host | NULL | Connect | NULL | login | NULL | 0 | 0 |  
| 2018434583 | unauthenticated user | :9395 | NULL | Connect | NULL | Reading from net | NULL | 0 | 0 |  
| 2018434586 | unauthenticated user | connecting host | NULL | Connect | NULL | login | NULL | 0 | 0 |  
| 2018434592 | unauthenticated user | connecting host | NULL | Connect | NULL | login | NULL | 0 | 0 |  
| 2018434595 | unauthenticated user | connecting host | NULL | Connect | NULL | login | NULL | 0 | 0 |  
| 2018434598 | unauthenticated user | connecting host | NULL | Connect | NULL | login | NULL | 0 | 0 |

I searched the internet and it said that this was related to the DNS problem. To fix this problem, simply start the mysql server with skip-name-resolve variable in my.cnf. However, I already set this variable in my.cnf and it still happening.

mysql\> show variables like ‘skip\_name\_resolve’;  
±------------------±------+  
| Variable\_name | Value |  
±------------------±------+  
| skip\_name\_resolve | ON |  
±------------------±------+  
1 row in set (0.10 sec)

Can anybody have met the same situation and give me some advice? My MySQL database version is 5.6.19-67.0

Thanks much!

Tony

---

<div class="post-metadata">

### Author: ![scott.nemes](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/scott.nemes/32/5_2.png) [@scott.nemes](https://forums.percona.com/u/scott.nemes)
#### Post date: [May 9, 2018, 1:16pm UTC](https://forums.percona.com/t/mysql-flooded-by-unauthenticated-user/6337/2 "2018-05-09T13:16:45Z")

</div>

Hi Jardenblack26;

If you’re getting a lot of them, and using SSL, it might also be SSL authentication related. So I would try disabling SSL to see if that helps. Then if that’s the problem, you’ll have to troubleshoot the root of the issue.

-Scott
