Forum Stats

  • 3,825,281 Users
  • 2,260,497 Discussions
  • 7,896,476 Comments

Discussions

Many void queries recorded in the mysql error log

CONCEPT21
CONCEPT21 Member Posts: 72 Red Ribbon
edited May 5, 2017 3:01PM in MySQL Community Space

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

Answers