Can not connet to mysql server 127.0.0.1

Asked May 21 '18 at 14:33

Active May 19 '19 at 10:04

Viewed 298 times

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.

i installed mysql server too in with workbench.help me

asked May 21 '18 at 14:33

ELIYADURAGE SRIYAN FERNANDO

things to try before asking SO: 1) Google. 2) try accessing MYSQL through command line. 3) Try seeing what services are being run on what ports. – treyBake May 21 '18 at 14:36
Is MySQL running on port 3306? Does the `root` user have rights to connect? Are you providing the correct password? – Álvaro González May 21 '18 at 14:36
Which OS are you using? Windows or Linux? – Nico Haase May 21 '18 at 14:38
Windows operating system – ELIYADURAGE SRIYAN FERNANDO May 21 '18 at 14:48
Sorry already solved – ELIYADURAGE SRIYAN FERNANDO May 21 '18 at 14:48

Can not connet to mysql server 127.0.0.1

0 Answers0

Linked