Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 234 Big Data Appliance
- 1.9K Data Science
- 449.7K Databases
- 221.5K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 477 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.8K SQL & PL/SQL
- 21.2K SQL Developer
- 295.3K Development
- 17 Developer Projects
- 138 Programming Languages
- 292K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 27 Java Learning Subscription
- 37K Database Connectivity
- 153 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 157 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 387 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1K Español
- 1.9K Japanese
- 230 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!
