How to resolve "access denied for user 'root'@'localhost' in mysql workbench windows"

Question

I have tried starting the mysql server but unanle to do so. I have changed the password which I am using while connecting to database, other things(hostname, port and username) remained same.

I have already checked mysql service in taskmanager, tried starting from command line and from mysql shell but still not able to succees.

C:\Program Files\MySQL\mysql-8.0.21-winx64\mysql-8.0.21-winx64\bin>mysql -u root -p Enter password: ************** ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

C:\Program Files\MySQL\mysql-8.0.21-winx64\mysql-8.0.21-winx64\bin>mysql start ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO)

Any help would be greatly appreciated.

Please find below the screenshots of the error.

Thank you for help, but I have already tried all the suggested methods mentioned in the post. After some google search I found that there were two mysql services (MySQL and MySQL80) running. I stopped the mysql service and started the Mysql80 service. This resolved my issue. — Prakriti Shaurya
– Prakriti Shaurya, Commented Sep 14, 2020 at 9:28

Gabrielly de Andrade · Accepted Answer · 2020-10-30 13:17:02Z

8

I was facing the same error. I could connect using terminal but not using workbench.

I follow these steps and it worked for me: https://phoenixnap.com/kb/access-denied-for-user-root-localhost

I run this command:

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'insert_password';

and then it was possible to access without admin privileges.

answered Oct 30, 2020 at 13:17

Gabrielly de Andrade

913 bronze badges

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

Comments

Prakriti Shaurya · Accepted Answer · 2020-09-18 04:53:01Z

2

Everytime I open the mysql workbench, I see the access denied error 'root'@'localhost'. The below resolution works for me:

Open taskmanager
Go to service tab
Open services
For me, two services run MySQL and MySQL80.
I stop the MySQL service and start the MySQL80 service.
This resolves my issue.

answered Sep 18, 2020 at 4:53

Prakriti Shaurya

1951 gold badge3 silver badges15 bronze badges

Comments

Prakriti Shaurya · Accepted Answer · 2020-09-14 09:31:01Z

0

After some google search, I found that there were two services MySQL and MySQL80 running in the services tab of task manager. I stopped the MySQL and started the MySQL80 service. This resolved my issue.

answered Sep 14, 2020 at 9:31

Prakriti Shaurya

1951 gold badge3 silver badges15 bronze badges

Comments

Mureinik · Accepted Answer · 2021-08-27 20:44:21Z

0

Go to C:/XAMPP/mysql/bin/
open my.ini (configuration setting type file)
under # The mysql server [mysqld] add a new line just after above heading and write skip-grant-tables enter image description here
ctrl+s (save)
open XAMPP control panel and click stop if your mysql server is already running and then click start again basically we are restarting the server and boom your problem is solved open workbench and try again to create a new connection.

edited Aug 27, 2021 at 20:44

Mureinik

316k54 gold badges399 silver badges405 bronze badges

answered Aug 27, 2021 at 15:33

juke box

112 bronze badges

Collectives™ on Stack Overflow

How to resolve "access denied for user 'root'@'localhost' in mysql workbench windows"

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related