Cannot Connect to Database Server mysql workbench

Question

I'm trying to connect to mysql workbench but I get the following error

Error Message Cannot Connect to Database Server

Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Could not open database.

Please: 1. Check that mysql is running on server 127.0.0.1

2. Check that mysql is running on port 3306 (note: 3306 is the default, but this can be changed)

3. Check the root has rights to connect to 127.0.0.1 from your address (mysql rights define what clients can connect to the server and from which machines)

4. Make sure you are both providing a password if needed and using the correct password for 127.0.0.1 connecting from the host address you're connecting

When I Test Connection, the parameters are correct, and actually I can enter and manage database in console. When I installed Mysql for first time I could enter to Workbench one time and if I closed Workbench I had to restart my PC to connect another time. I reinstalled 2 or 3 times Mysql server and Workbench and now I cannot connect from Workbench even once.

Solution 1

I faced similar issue and resolved it by following these steps:

1. In the terminal, execute this command mysql -u root -p -h localhost -P 3306
2. Enter the password
3. This will be displayed Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 18 Server version: 8.0.16 Homebrew
4. Now do, ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root';
5. Now you should be able to login and connect to DB in the workbench with password 'root'

Solution 2

I don't know if it helps anyone, but I had the same problem on windows after updating from MySQL 5.7 to 8.0.

The solution for me was to go to services.msc, stop the MySQL service and start the "MySQL80" service instead.

Then I restarted MySQL Workbench (run as admin) and it worked.