Many void queries recorded in the mysql error log

CONCEPT21

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)

CONCEPT21

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! 

Dave Stokes-MySQL Community Team-Oracle

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!

CONCEPT21

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!