Can't connect to MySQL server on '127.0.0.1' (10061) (2003)

4.7K    Asked by CarolBower in SQL Server , Asked on Jun 2, 2021

Recently I had downloaded the MySQL Workbench 6.1 on the Windows 7 operating system and now I need to start it and do a simple DB. I set up a new MySQL Connection and let it default the Hostname, port, and username. I had just set the name of the connection. In the start, it was showing down in the action output that Could not connect. The server was not even running and it show error  "Can't connect to MySQL server on '127.0.0.1' (10061)" but I thought I would be able to do a DB and test it Then I created a simple DB and when I wanted to execute it I could not press the Bolt which executes the DB so I tried from the Query and I clicked the 2nd option which is "Execute(All or Selection) to text" as I couldn't choose any other option and this error was shown Can't connect to MySQL server on '127.0.0.1' (10061) (2003)

I am new to this, I have used SQL*Plus for a while but it is not the same

Answered by Clare Matthews

Getting the error “can t connect to mysql server on 127.0 0.1” means you are migrating the MySql database files to a new location.

If you have already installed MySQL on a Windows machine make sure that it is running as a service.

You can check by doing the following steps showm below:

Start --> services --> MySQL(ver) --> Right-Click --> Start.



Your Answer

Interviews

Parent Categories