Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 238 Big Data Appliance
- 1.9K Data Science
- 450.3K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 544 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.8K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.5K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 155 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 437 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
Many void queries recorded in the mysql error log

Hello all the Mysql users,
My system is Ubuntu 16.04 amd64, Mysql server 5.7.18.
The mysql error log is flooded with these void queries. They happen about twice per 2 minutes. How do I find out which program or connection is responsible for them?
2017-05-01T17:27:15.908503Z 3 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2017-05-01T17:29:17.320641Z 23 [Note] Access denied for user ''@'localhost' (using password: NO)
2017-05-01T17:29:17.321477Z 24 [Note] Access denied for user ''@'localhost' (using password: NO)
2017-05-01T17:31:17.404669Z 36 [Note] Access denied for user ''@'localhost' (using password: NO)
2017-05-01T17:31:17.405018Z 37 [Note] Access denied for user ''@'localhost' (using password: NO)
2017-05-01T17:33:17.482127Z 47 [Note] Access denied for user ''@'localhost' (using password: NO)
2017-05-01T17:33:17.482912Z 48 [Note] Access denied for user ''@'localhost' (using password: NO)
Best Answer
-
OK! I found that it is Monit and Mysql 5.7 which does not allow anonymous user. So I add a new identity in the Monit's config and the warnings have gone!
Answers
-
For other non-root accounts you can disable that account and not worry. With root you have to worry.
First check you lists of acceptable hosts to make sure the outside world has ZERO access to your database.
If you are running the Community Edition, look at the audit plugin at https://github.com/outbrain/audit_login
as it records IP addresses.
Good luck!
Dave Stokes
MySQL Community Manager
-
OK! I found that it is Monit and Mysql 5.7 which does not allow anonymous user. So I add a new identity in the Monit's config and the warnings have gone!