Home/ Questions/Fix to "failed to connect to mysql at localhost 3306 with user root".
Next
Answered
brennastiedemann
  • 3
Asked: 2022-06-28T03:37:51+00:00 In:

Fix to “failed to connect to mysql at localhost 3306 with user root”.

  • 3

. Advertisement .

..3..

. Advertisement .

..4..

Hello everyone, I’m having a problem which I’ve been trying to connect but it appears this error “failed to connect to mysql at localhost 3306 with user root”:

Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user 'root'@'localhost'(using password:YES)

I’ve refered some documents but I can not find the error. This test is important for me, please help me if you know the answer. Thank you!

failed to connect to mysql at localhost 3306 with user root
Share

1 Answer

  1. Best Answer
    Expert

    The cause:

    The software may not have been completely removed from your device since there may have been an issue when removing it.

    The solution:

    First, see if the issue is with the workbench or the connection. Open a terminal by runing “cmd” in your windows.

    Do by 2 ways:

    2a)

    mysql -u root -p -h 127.0.0.1 -P 3306

    2b)

    mysql -u root -p -h > localhost -P 3306

    3) If the connection is strong, a password prompt will appear; try to connect using the right password. Whenever your connection is rejected, simply accept the permission.

    mysql >GRANT ALL ON [DatabaseName].* TO 'root'@'127.0.0.1' IDENTIFIED BY '[PASSWORD]';

    If your connection is recognized here, the issue is comparable to a workbench configuration issue.

    • 3

Leave an answer

You must login to add an answer.

Need An Account,