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 been trying to create a new database connection on workbench. However, every time I test a connection there is an error message that says
Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user 'root'@'localhost'(using password:YES)
I don't know what's the cause of this error. I have tried uninstalling and re-installing my workbench 6.1 and mysql server 5.6 but the error is still unsolved.
Answer
First check if it's a workbench or connection problem.
1) In your windows run 'cmd' to open a terminal
Try both
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 good you will get a password prompt, see if you can connect with correct password.
If your connection is denied, just grant the permission
mysql >GRANT ALL ON [DatabaseName].* TO 'root'@'127.0.0.1' IDENTIFIED BY '[PASSWORD]';
If your connection is accepted here, it's like a workbench configuration problem.