CODEWITHSUNDEEP
mysqldatabasemysql-workbench
Lo-urc
Lo-urc

Reputation: 192

Cant connect to mysql db by workbench but can log in via terminal

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.

Upvotes: 0

Views: 115

Answers (2)

Lo-urc
Lo-urc

Reputation: 192

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.

Upvotes: 0

chnz2k
chnz2k

Reputation: 82

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

Upvotes: 1

Related Questions