Question

[Solved] Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)

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.

Thanks in advance.

Enquirer: Zee E.

||

Solution #1:

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
FilesMySQLMySQL Server 5.5inmysqld” –install

Respondent: Jens

Solution #2:

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

Respondent: Techno Buzz

Solution #3:

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.

Respondent: Gabriel

Solution #4:

(Windows) If you have already installed MySQL server

cd C:Program FilesMySQLMySQL Server X.Xin
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:
enter image description here

Respondent: Broper

Solution #5:

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

Respondent: Deepak Gautam

Solution #6:

I solved the problem as follows:

  1. run MySQLInstanceConfig.exe

    C:Program Files (x86)MySQLMySQL Server 5.1inMySQLInstanceConfig.exe

  2. Follow to the end without changing anything.

Respondent: Vitorino

Solution #7:

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

C:wampinmysqlmysql5.6.17inmysqld.exe --console

You should be able to see following result:

enter image description here

Respondent: Hamid Hoseini

Solution #8:

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

Respondent: konyak

Solution #9:

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

Respondent: Reuben The Coder

Solution #10:

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.

Respondent: somdow

Solution #11:

To re-iterate what Jens wrote in more current code, first open the Command Prompt with Administrator access by right-clicking the Command Prompt icon and select “Run as administrator.” Then cut and paste the following into the Command Prompt at the C:> directory level:

"C:Program Files (x86)MySQLMySQL Server 5.6inmysqld" --install 

You may have to change the name of the folder depending on where MySQL is installed and what version it is.

Respondent: davidrynn

Solution #12:

In my case I had a previous mySQL server installation (with non-standard port), and I re-installed to a different directory & port. Then I got the same issue. To resolve, you click on home + add new connection.

If you need to know the port of your server, you can find it when you start My SQL command line client via All Programs -> MySQL -> MySQL ServerX.Y -> MySQL X.Y Command Line Client and run command status (as below)

how to create

how to find port

Respondent: Orhan Celik

Solution #13:

If you have already created a localhost connection and its still showing can not connect then goto taskbar and find the MySQL notifier icon. Click on that and check whether your connection name is running or stopped. If its stopped then start or restart. I was facing the same issue but it fixed my problem.

Respondent: Syed Khaliq

Solution #14:

I encountered a similar problem. I am using WinNMP. When I started it, MariaDB was also not running and prompts “Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)” whenever I try to connect to a database.

Just want to help. For WinNMP users like me, this worked for me:

  1. Run msyqld installer located at "C:WinNMPinMariaDBin".
  2. Restart your WinNMP.
  3. MariaDB should be running now.

Hope this helps someone! ๐Ÿ˜€

Solution #15:

Slightly different case, but it may help someone.

I followed the instructions to create a secondary database instance, and I had to clone the ini file as part of that. It was failing to start the service, with the same error. Turns out notepad.exe had re-encoded the cloned ini file as UTF8-BOM, and MySQL (version 8) refused to work with it. Removing the BOM fixed the problem.

Respondent: kostasvs

Solution #16:

I know that there are a lot of answers to this question already already but i wanted to share my experience as none of the answers provided fixed this issue for me.

After about a day of exploring different solutions I believe the issue was that I have recently installed XAMPP and it was interfering with the MySQL workbench. I have tried changing the port numbers however this hasn’t helped, and it seems that both programs are sharing configuration files.
Repairing MySQL in the Control Panel didn’t resolve it, so now I am uninstalling MySQL and plan to reinstall it. Another potential solution maybe to uninstall XAMPP however the config files may either be deleted, or left in the xampp folder instead of the MySQL folder by doing so.

Respondent: Haggishunt56

Solution #17:

I simply used mysql installer to reconfigure the server instance http://prntscr.com/wcl3p9

Respondent: alvarosmh

The answers/resolutions are collected from stackoverflow, are licensed under cc by-sa 2.5 , cc by-sa 3.0 and cc by-sa 4.0 .

Most Popular

To Top
India and Pakistanโ€™s steroid-soaked rhetoric over Kashmir will come back to haunt them both clenbuterol australia bossier man pleads guilty for leadership role in anabolic steriod distribution conspiracy