mysql无法连接到数据库服务器失败_无法连接到数据库服务器mysql工作台

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

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

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)

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.

解决方案

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