Skip to main content

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



  • cPRex Jurassic Moderator

    Hey there!  Does it just say "user" and not the actual username?  This seems to be happening frequently enough that you could temporarily enable the general query log to get more details about what is making that call:

    but that should only be implemented for short periods of time as it will log *everything* and could cause the server to run out of disk space.

  • Khanh Cuong

    Hi Support,

    Does it just say "user" and not the actual username?

    That's right

    I got this error when I transferred data from one cpanel to a cpanel with higher mysql version.

    I have Enable MySQL General Query Log, And realized there could be errors in the users being backed up.

    2024-04-18T04:38:40.983744Z    16900 Connect    @localhost on  using Socket
    2024-04-18T04:38:40.983798Z    16900 Connect    Access denied for user ''@'localhost' (using password: NO)
    2024-04-18T04:38:40.984570Z    16901 Connect    ng0cviet_cambo@localhost on  using Socket
    2024-04-18T04:38:40.984793Z    16901 Init DB    ng0cviet_cambo

    Now how do I turn off the [Note] Access denied for user ''@'localhost' (using password: NO) warning in mysql log?


  • cPRex Jurassic Moderator

    There isn't going to be a way to turn that off - you'll want to resolve the root of the issue causing the error to stop that from being logged.


Please sign in to leave a comment.