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.

Lo-urc
  • 192
  • 1
  • 4
  • 15

2 Answers2

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

chnz2k
  • 82
  • 5
  • This surely can't be the issue though as I have the correct password and user for logging in via terminal – Lo-urc May 11 '19 at 21:04
  • 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 – chnz2k May 11 '19 at 21:07
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.

Lo-urc
  • 192
  • 1
  • 4
  • 15