MySQL error log full of [Warning] Access denied for user ''@'localhost' (using password: NO)

stormy

• November 26, 2016 12:48

I'm trying to fine-tune MySQL and troubleshoot a few issues, so I enabled log-warnings=2. I see that the MySQL error log is full of these: [Warning] Access denied for user ''@'localhost' (using password: NO) I suppose it's a user with a misconfigured site/connection. Is there any way to track the source of this?

• 

  SysSachin

  • November 27, 2016 04:14

  You will have to find out all sites MySQL details from site configuration files. Could you please let me know how many sites you have hosted on your server? You can find out all sites databases details through command line using grep or any other command.

  0
• 

  stormy

  • November 28, 2016 14:41

  Well, there are about 500 accounts on this particular server. Not sure what to grep for...

  0
• 

  cPanelMichael

  • November 28, 2016 20:16

  Hello, The following thread discusses a solution that would help if you want to log this activity in the future: Access Logs for MySQL However, note that it's not enabled by default so you won't be able to go back and review past connections. Thank you.

  0
• 

  rpvw

  • November 28, 2016 20:16

  Could these connections from an unspecified user be from the service manager checking to see if MySQL is alive ?

  0
• 

  Esquio

  • February 22, 2022 10:46

  Could these connections from an unspecified user be from the service manager checking to see if MySQL is alive ?

  
  Hi! My server have the same problem. Did you find any solution? It's not an accounts problem, is clearly something on the system. I have binding to localhost all mysql connections, I flush privileges and many configs on root password, nothing works. Every 3 seconds, 3 rows are written on the log until the infinite:
  2022-02-22 12:43:34 2659 [Warning] Access denied for user 'root'@'localhost' (using password: NO) 2022-02-22 12:43:34 2661 [Warning] Access denied for user 'root'@'localhost' (using password: NO) 2022-02-22 12:43:34 2663 [Warning] Access denied for user 'root'@'localhost' (using password: NO) 2022-02-22 12:43:37 2670 [Warning] Access denied for user 'root'@'localhost' (using password: NO) 2022-02-22 12:43:37 2672 [Warning] Access denied for user 'root'@'localhost' (using password: NO) 2022-02-22 12:43:37 2674 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
  At least, how can I rotate the logs or automatically remove these lines?

  0
• 

  Khanh Cuong

  • April 16, 2024 19:10

  It seems the issue is still not resolved

  0
• 

  cPRex Jurassic Moderator

  • April 17, 2024 16:09

  Khanh Cuong - this thread is several years old, so we would likely need a new thread with specific details about your situation in order to help.

  0

Please sign in to leave a comment.