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

Question

I know this question was asked a lot before but I tried some of the solutions which were given and nothing worked.

I have downloaded MySQL Workbench 6.1 on my windows 7 x64 and now as I want to start and do a simple DB I set a new MySQL Connection and let it as default the Hostname, port and the username I just set the name of the connection. In the beginning it was showing down in the action output that Could not connect. Server may not be run and in the msg part it was written 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 couldn't press the Bolt which execute the DB so I tried from Query and I pressed 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 in this I have used SQL*Plus for a while but it is not the same.

Look to the [official documentation] (http://dev.mysql.com/doc/refman/5.5/en/windows-start-service.html) of MySQL — Jens, Jul 02 '14 at 08:22
Check here (http://www.rathishkumar.in/2017/08/solved-cannot-connect-to-mysql-server.html) for all possible reasons and workaround for this error — Rathish Kumar B, Aug 06 '17 at 17:03
This problem generally arises if your XAMPP server is not started untill you hit start. first start XAMPP server then start mysql tool — Koyel Sharma, Apr 21 '18 at 06:41

score 92 · Answer 1 · answered Oct 27 '16 at 06:59

92

If you have already installed MySQL on a windows machine make sure it is running as a service.. You can do that by

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

answered Oct 27 '16 at 06:59

Techno Buzz

937
6
3

Is there another "easier" method to start the server? – Andrei Manolache May 27 '20 at 23:37
This is the easiest most basic thing to check first. I can't understand why people are keep on debugging complex stuff – codingbruh Oct 04 '22 at 15:57

Jens · Accepted Answer · 2015-02-03T11:18:18.103

57

Looks like the mysql server is not started.

Look to the official documentation of MySQL how you can start a service under windows.

Install the server as a service using this command: C:> "C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld" --install

edited Feb 03 '15 at 11:18

answered Jul 03 '14 at 08:10

Jens

67,715
15
98
113

10

its keeps saying install/remove denied – Rocketq Oct 18 '17 at 18:49
@Downvoter: Please explain why else it is not usefull – Jens Mar 24 '18 at 15:03
Some time might be your server has been started but your host/IP will be different. So need to check ip as well. It happened in my case. then i run MySQLInstanceConfig.exe and just follwed the instruction which told me the current ip configured. – abhishek prasad Jan 28 '19 at 16:34
1

@Rocketq try to run CMD as an Admin – Bang Fady Feb 02 '20 at 13:51

score 41 · Answer 3 · edited Dec 18 '20 at 14:25

41

I was facing the same problem, but what I did not realise is that I did not have the MySQL Server installed. You must simply install the MySQL Server.

In order to install the MySQL server, you must run the "MySql Installer" and then press the "Add" button and then choose the "MySQL Server" in the tree.

After doing that, run you workbench again and you'll notice that there'll already be a connection configured. Hopefully, you'll be able to create a new connection or as many connections as you want.

edited Dec 18 '20 at 14:25

Dharman

30,962
25
85
135

answered Feb 02 '15 at 11:28

Gabriel

488
4
8

saved my life in 2022 :) really strange that it's not clearer in the actual installation flow but hey thanks! worked for me.. – DCX Jul 26 '22 at 17:15

score 29 · Answer 4 · answered Jan 30 '18 at 21:21

(Windows) If you have already installed MySQL server

cd C:\Program Files\MySQL\MySQL Server X.X\bin mysqld --install

and still cannot connect, then the service did not start automatically. Just try

Start > Search "services"

and scroll down until you see "MySQLXX", where the XX represents the MySQL Server version. If the Status isn't "Started", then

Right Click > Start

If you are here you should be golden:

Deepak Gautam · Answer 5 · 2017-03-24T15:03:12.300

16

In Windows goto task-manager >"services" and check that "MySQL" is runing. If not
Right click on it ->open services->MySQL-> startup type -> 'Automatic' -> apply and OK. this is for windows 10 MySql 5.7

edited Mar 24 '17 at 15:03

answered Feb 22 '17 at 12:16

Deepak Gautam

1,309
12
14

score 7 · Answer 6 · edited Oct 27 '14 at 00:47

7

I solved the problem as follows:

run MySQLInstanceConfig.exe

C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\MySQLInstanceConfig.exe
Follow to the end without changing anything.

edited Oct 27 '14 at 00:47

andrewsi

10,807
132
35
51

answered Oct 27 '14 at 00:43

Vitorino

79
1
2

4

I am using MySQL Server 8.0 and the executable does not exist. – posfan12 Sep 17 '19 at 00:46

score 5 · Answer 7 · edited Apr 16 '16 at 00:55

5

maybe it has a different solution, but I fixed it by finding mysqld.exe and running following command in the console:

C:\wamp\bin\mysql\mysql5.6.17\bin\mysqld.exe --console

You should be able to see following result:

edited Apr 16 '16 at 00:55

derekerdmann

17,696
11
76
110

answered Apr 16 '16 at 00:33

Hamid Hoseini

1,560
17
21

score 3 · Answer 8 · answered Oct 15 '15 at 23:35

3

Avoid using bind_address in your my.cnf file, if you have any.

Ref: http://dev.mysql.com/doc/refman/5.5/en/can-not-connect-to-server.html

answered Oct 15 '15 at 23:35

konyak

10,818
4
59
65

This answer helped me. Because my MySql service was already running. My IP was allowed to connect to server with mysql client. But in /etc/my.cnf file "bind_address" was 127.0.0.1. That I removed to resolve the problem. and restarted mysql service and here I am now able to connect with mysql server using mysql client. Tone of thanks – Sohel Pathan Apr 11 '17 at 05:22

score 2 · Answer 9 · edited Feb 17 '21 at 00:07

2

In my case, I had installed a new installation of MYSQL(8) and WORKBENCH etc. so that I could then work on an old WordPress website. No matter what I did, it wouldn't work. Kept getting "ERROR ESTABLISHING CONNECTION" etc. Thinking that it was maybe something to do with WordPress(since it is old), I tried a basic manual connection with PHP and nothing.

Eventually, I figured out that I had to downgrade MySQL. So I went back to MYSQL installer, found the server, and downgraded MYSQL from 8.0 back to 5.5

As soon as I did that, everything worked.

edited Feb 17 '21 at 00:07

Dharman

30,962
25
85
135

answered Jun 29 '19 at 16:01

somdow

6,268
10
40
58

1

I had the same problem. It was not connecting. I followed your advice and also downgraded it to 5.5. Its now working perfectly. Thanks. – Djesu Oct 22 '20 at 19:45

score 1 · Answer 10 · edited Jun 03 '22 at 03:55

1

Resolved this issue by navigating to C:\xampp\mysql\bin and double clicking on mysqld.exe and then allow access in the pop up that comes. My server status on workbench changed to running.

edited Jun 03 '22 at 03:55

cottontail

10,268
18
50
51

answered Jun 10 '19 at 10:24

Reuben Frimpong

73
10

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

10 Answers10

Linked