0

Im trying to connect to a mysql database crated on my local, however when I try to log in on mysql-workbench I get the following error:

  Access denied for user 'root'@'localhost' (using password: YES)

My password is the standard password, and my user is root.. What I find even stranger is that if I try and log in too the db using mysql -u root -p and then proceed to enter the password password I log in fine no issue? Has anything experienced this before?

I have double checked everything, mysql workbench even recognizes a databse is active on my localhost on the initial interface.

Improve this question

2 Answers 2

Reset to default
1

try to reset the root passwd from here : https://support.rackspace.com/how-to/mysql-resetting-a-lost-mysql-root-password/

or follow this : How to change the mysql root password

Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

This surely can't be the issue though as I have the correct password and user for logging in via terminal
i had the same issue in the past i used to reset the password , or reinstall & purge your mysql server from begin . Sometimes mariadb & mysql-common made issues toghter on while same machine . hope this help u out
0

May I also add that I was stupidly using my mysql password where I was meant to use my system password, wasted many hours due to this.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.