5

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

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

  2. 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)

  3. 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.

Improve this question
8
  • Is MySQL installed in your localhost or in a server? Commented Mar 9, 2015 at 19:41
  • @bcesars In localhost, but I also tried to connect to a server, and I get the same, when I test de connection it says that parameters are correct but I can't connect. Im new in this, not sure if that is what you meant Commented Mar 9, 2015 at 20:30
  • Error message says that ist could not open DATABASE. And you said that you reinstalled mysql. Ist that schema you try to connect to still present? Commented Mar 9, 2015 at 20:33
  • @SOehl I left empty the field "Default Schema" , And put a database too but gives me the same message Commented Mar 9, 2015 at 20:41
  • if you're trying to connect as root, then please try to connect to schema mysql. Commented Mar 9, 2015 at 20:46

6 Answers 6

Reset to default
3

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'
Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

This worked!! The key here is mysql_native_password.
1

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.

Improve this answer

Comments

1

In the run window ( in Windows use windows + r ) and search for services.msc

enter image description here

Now search for MySQL 80

enter image description here

On the left hand, you can see an option to restart click on that wait for a few seconds to complete and your MySQL should now be working fine.

Improve this answer

Comments

0

Please make sure that You have Downloaded MySQl server while dowloading MySQl workbench from MySQl installer (if you have checked Custom download)

Improve this answer

Comments

0

I had the same issue a few days ago. As I could see in the original question, there has been multiple MySQL installation on the same computer - the same flow I tried after failing in the first attempt.

In the case we are trying to reinstall MySQL, we should be aware of remaining hidden files after MySQL has been uninstalled for the first time. In order to remove them all (and make one successful installation), we should:

  1. Make hidden files visible on your computer (instructions)
  2. Delete all files related to MySQL after choosing uninstalling of the MySQL (I had to check C://ProgramData hidden folder)
  3. Try a new installation

I think that during the first installation, I didn't have all required dependencies on the computer (for example Python) and the installation failed. After installing it, uninstalling the MySQL, and taking steps from above, I finally managed to run it successfully :)

I hope this could help someone! :)

Improve this answer

Comments

0

This solved it for me (MAC OS)

  1. Open MySQL from System Preferences > MySQL
  2. Click 'Stop MySQL Server' if the server is running
  3. Select 'Initialize Database'
  4. Type your new password.
  5. Choose 'Use legacy password'
  6. Start the Server again.
  7. Now connect the MySQL Workbench
Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.