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

Question

Recently I had downloaded the MySQL Workbench 6.1 on the windows 7 operating system and now as I need to start it and do a simple DB. I set up a new MySQL Connection and let it as default the Hostname, port and the 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 shown 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 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.

Answer 1

If you are already having the MySQL installed on a Windows machine make sure that it is running as a service. You can do that by

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

If you want to learn more about SQL, Check out this Microsoft SQL Certification by Intellipaat.

For more information visit :