Skip to main content

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

Khanh Cuong

I see that the MySQL error log is full of these: [NOTE] 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?

2024-04-17T16:06:46.129228Z 595459 [Note] Access denied for user ''@'localhost' (using password: NO)
2024-04-17T16:06:47.682138Z 595463 [Note] Access denied for user ''@'localhost' (using password: NO)
2024-04-17T16:06:49.687016Z 595468 [Note] Access denied for user ''@'localhost' (using password: NO)
2024-04-17T16:06:50.417193Z 595471 [Note] Access denied for user ''@'localhost' (using password: NO)
2024-04-17T16:06:52.060667Z 595476 [Note] Access denied for user ''@'localhost' (using password: NO)
2024-04-17T16:06:52.185354Z 595478 [Note] Access denied for user ''@'localhost' (using password: NO)
2024-04-17T16:06:54.693508Z 595482 [Note] Access denied for user ''@'localhost' (using password: NO)
2024-04-17T16:06:55.540715Z 595485 [Note] Access denied for user ''@'localhost' (using password: NO)
2024-04-17T16:06:58.872119Z 595495 [Note] Access denied for user ''@'localhost' (using password: NO)
2024-04-17T16:06:58.877357Z 595497 [Note] Access denied for user ''@'localhost' (using password: NO)
2024-04-17T16:06:59.920520Z 595504 [Note] Access denied for user ''@'localhost' (using password: NO)
2024-04-17T16:07:01.799214Z 595509 [Note] Access denied for user ''@'localhost' (using password: NO)
2024-04-17T16:07:03.502138Z 595516 [Note] Access denied for user ''@'localhost' (using password: NO)
2024-04-17T16:07:03.583364Z 595518 [Note] Access denied for user ''@'localhost' (using password: NO)
2024-04-17T16:07:03.837578Z 595520 [Note] Access denied for user ''@'localhost' (using password: NO)
2024-04-17T16:07:03.936985Z 595522 [Note] Access denied for user ''@'localhost' (using password: NO)
2024-04-17T16:07:04.598636Z 595525 [Note] Access denied for user ''@'localhost' (using password: NO)
2024-04-17T16:07:04.909233Z 595527 [Note] Access denied for user ''@'localhost' (using password: NO)
2024-04-17T16:07:05.169188Z 595529 [Note] Access denied for user ''@'localhost' (using password: NO)
2024-04-17T16:07:06.698887Z 595533 [Note] Access denied for user ''@'localhost' (using password: NO)
2024-04-17T16:07:08.134605Z 595538 [Note] Access denied for user ''@'localhost' (using password: NO)
2024-04-17T16:07:08.639083Z 595541 [Note] Access denied for user ''@'localhost' (using password: NO)
2024-04-17T16:07:09.012382Z 595543 [Note] Access denied for user ''@'localhost' (using password: NO)
2024-04-17T16:07:11.681470Z 595556 [Note] Access denied for user ''@'localhost' (using password: NO)
2024-04-17T16:07:11.729146Z 595558 [Note] Access denied for user ''@'localhost' (using password: NO)
2024-04-17T16:07:12.219442Z 595560 [Note] Access denied for user ''@'localhost' (using password: NO)
2024-04-17T16:07:12.783377Z 595562 [Note] Access denied for user ''@'localhost' (using password: NO)
2024-04-17T16:07:13.064803Z 595564 [Note] Access denied for user ''@'localhost' (using password: NO)
2024-04-17T16:07:13.933523Z 595567 [Note] Access denied for user ''@'localhost' (using password: NO)
2024-04-17T16:07:14.341768Z 595570 [Note] Access denied for user ''@'localhost' (using password: NO)
2024-04-17T16:07:15.852207Z 595575 [Note] Access denied for user ''@'localhost' (using password: NO)
2024-04-17T16:07:16.085426Z 595577 [Note] Access denied for user ''@'localhost' (using password: NO)
2024-04-17T16:07:16.414354Z 595581 [Note] Access denied for user ''@'localhost' (using password: NO)
2024-04-17T16:07:16.808358Z 595583 [Note] Access denied for user ''@'localhost' (using password: NO)

Comments

3 comments

Date Votes
  • 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:

    https://support.cpanel.net/hc/en-us/articles/360051031694-Enable-MySQL-General-Query-Log

    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.

    0
  • 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?

     

    0
  • 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.

    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post