[mysql] Can't connect to MySQL server on 'localhost' (10061) after Installation

I installed MySQL using mysql-installer-5.5.20.0.msi on Windows 7. From the cmd window, I run "mysqlshow -u root -p". It asked for a password, then returned this error: "Can't connect to MySQL server on 'localhost' (10061)" This is a bad indication of partially failed/successful installation.

After reading the page, http://dev.mysql.com/doc/refman/5.5/en/windows-troubleshooting.html, it told me to find an error log (.err) in C:\Program Files\MySQL\MySQL Server 5.5\data. The directory exists but there is no log file.

I have a feeling this is related to the tight security of Windows 7, especially when installing a Unix based software. And yes, I am the Administrator on my PC.

Any help or suggestions is appreciated. And I can return a favor by answering Java and SQL query questions.

I solved this by adding the following arguments to the command line string:

mysql --user username --password password --host localhost --port 3306 databasename < "system path to .sql file"

Without the --host and --port arguments, especially if you change the port to let's say 3307, which is a non default value, will cause this error.

Please Try the following steps:

1. c:\mysql\bin>mysqld --install
2. c:\mysql\bin>mysqld --initialize

then press "Windows key + R" write "services.msc", run as admin

start MySQL service.

This is the easiest solution and worked for me.

• Go to where you downloaded "mysql-installer-web-community-8.0.19.0.msi", file for installing mysql.
• Run this by double clicking on it. (No need to uninstall anything)
• Click on "reconfigure" beside the MySql server.
• Agree everything which comes in middle, provide password for root where asked.
• Finish. That's it you're good to go.

The simple solution that worked for me is: change localhost to 127.0.0.1 in your database.yml or in your script if writing one.

From what I've gathered this means the mysql service (mysqld) isn't running.

• First make sure it is installed as a windows service : Run

"C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld" --install

from the command line.

• Next, start it up :

services.msc > MySQL > start

If it fails to restart, then you can follow these steps :

• open the command line as an administrator : cmd.exe > open as administrator
• run "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld" --verbose

it should fail and put the error log in a directory named data under C:\Program Files\MySQL\MysSQL Server 5.7\ . If it fails to create data for some reason, do it manually under that directory and try again. If you can figure out what's missing from what's in that log, then good, you're done.

If you've still got no luck, this is how I did it :

• goto C:\ProgramData\MySQL and copy the file named my.ini to C:\Windows\

• try to start the service again from the command line : "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld" --verbose

If it doesn't display any error, than the service startup was successfull. If it's still not working, than delete that my.ini you just copied from C:\Windows and start the service from the command line once again.

it should work now

Just turn off the firewall and remove the instance configuration. Add a new instance for the server.![Disable Firewall][1] Give he port number correctly as 3306 as default

I had the same issue and basically resolved it by pointing to a specific port number that my MySQL server was running on. Below is the command. Please edit the code to fit your case i.e your port number,your mysql server username,your password.

    mysql -u root -pYourMysqlRootPassword -P3307 

For anyone who have the same problem of "Can't connect to MySQL server on 'localhost' (10061) " or "Can't connect to MySQL server on '127.0.0.1' (10061) ". You can install "MySQL Installer" and this is the link http://dev.mysql.com/downloads/windows/installer/5.6.html and this is a tutoriel for more help https://www.youtube.com/watch?v=AqQc3YqfelE

it works for me and i wish to work for you too.

I had this error - stupid mistake was, I was using -p3307 to specify port, whereas I should have used -P3307, i.e. capital P. Small 'p' is for password arg :)

1. Create the temp folder c:/mysqltmp
2. In my.ini file under [mysqld] add the line tmpdir=c:/mysqltmp
3. Add full privileges to user NETWORK SERVICE for "C:\ProgramData\MySQL\MySQL Server X.Y\Data\ibdata1" file
4. Start service

These are steps for the same problem with MySQL5.7 and MySQL8.0 on Windows 10

I had the same error. I resolved in this way

Go to start- MySQL Installer-community and run again the installer as a re-configuration(you will be asked so).

Once asked if you want make MySQL instance to run as a Windows service, check the box.

In case would do not work, try unistalling and installing again, and check the box to run MySQL as Windows service.

For me, three steps solved this problem on windows 10:

I downloaded MySQL server community edition zip and extracted it in the D drive. After that I went to bin folder and did cmd on that folder. I followed the below steps and all works:

D:\tools\mysql-8.0.17-winx64\bin>mysqld -install
Service successfully installed.

D:\tools\mysql-8.0.17-winx64\bin>mysqld --initialize
D:\tools\mysql-8.0.17-winx64\bin>net start mysql
The MySQL service is starting...
The MySQL service was started successfully.

for who person that want use mysql or mariadb with out any error i suggest use version 5.5 just download a zip file mariadb-5.5.65-winx64.zip from https://downloads.mariadb.org/mariadb/5.5.65/ and to install follow this tutorial setp by step https://www.youtube.com/watch?v=uEPs6JsTZFc (this tutorial works well for version 5.5 too )

Well in my case I just opened services.msc using run and restarted 2 of the services related to mysql and it worked!

I too had this problem, its easy to solve:

Go to Control panel - System and maintenance - System - Advanced system settings - Environment variables - System variables - path - click edit - add

"c:\xampp\mysql\bin" - it should look like this :

\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\Intel\OpenCL SDK\2.0\bin\x86;C:\Program Files (x86)\Intel\OpenCL SDK\2.0\bin\x64;C:\Program Files (x86)\Windows Live\Shared;C:\Program Files (x86)\QuickTime Alternative\QTSystem;c:\xampp\mysql\bin

And don't forget to start MySQL from control panel of Xampp.

This saved my life,

mysqld --tc-heuristic-recover=ROLLBACK

Read more

I found the same error re occurring even after I tried all the above solutions given above. I had even tried version 5.7 and few more. Guys don't waste your time trying to fix it. Rather install version 5.5. It's working perfectly fine without any unnecessary error.

Solution 1:

For 32bit: Run "mysql.exe" from: C:\Program Files\MySQL\MySQL Server 5.6\bin

For 64bit: Run "MySQLInstanceConfig.exe" from: C:\Program Files\MySQL\MySQL Server 5.6\bin

Solution 2:

The error (2002) Can't connect to ... normally means that there is no MySQL server running on the system or that you are using an incorrect Unix socket file name or TCP/IP port number when trying to connect to the server. You should also check that the TCP/IP port you are using has not been blocked by a firewall or port blocking service.

The error (2003) Can't connect to MySQL server on 'server' (10061) indicates that the network connection has been refused. You should check that there is a MySQL server running, that it has network connections enabled, and that the network port you specified is the one configured on the server.

Source: http://dev.mysql.com/doc/refman/5.6/en/starting-server.html Visit it for more information.

For the 5.7 version, I had the same problem and a simple fix did the trick. As Installed the workbench 5.7 there was another "software" of sorts called the "MySQL Installer Community". I ran this and ran the "Reconfigure" for the MySQL server. It took about a minute and the problem was no longer there.

Hope it works!.(Keep in mind i was using the 5.7 version)

press Windows+R it opens Run then.. Enter services.msc

then Find out mysql right click and start

it works

In Windows 7

1. press Windows+R it opens Run
2. Enter services.msc
3. Find out mysql right click and start
4. if mysql was not found
   1. Run cmd as administrator
   2. goto C:\Program Files (x86)\MySQL\MySQL Server 5.6\bin directory(to go back use cd..) and type mysqld.exe --install
5. follow step 3

That's all

Turn off firewall and restart mysql server. then turn on firewall. It's the easy way! just try it

if it is showing error 2003 (HY000): Can't connect to MySQL server on localhost (10061) than

1. Search services.msc in run
2. goto mysql properties
3. copy the mysql service name
4. start cmd as administrator
5. write: net start mysqlservicename .i.e mysql57 or etc it will show mysql is starting.

Don't do useless stuff like reconfigure, stop MySQL and start MySQL in service. Just reinstall the MYSQL server and again install it in your system. Remember only uninstall MySQL server and nothing else. All the problem will be solve automatically

1. In Start Menu, search for "mysql". Among the results, you should see the "MySQL Installer - Community". Run it.

2. MySQL Installer window will show up as shown below. Find "MySQL Server" under Product and click on "Reconfigure" link.

3. The MySQL Installer will show up (same one you used for the first MySQL Server installation). Go through all the steps.

4. After the MySQL Installer was finished, I started the MySQL service again. This time, the "Startup Message Log" on The MySQL Notifier was showing that the server started successfully:

https://www.howtosolutions.net/2017/08/fixing-mysql-10061-error-after-migration-of-database-files/

I have Windows 8.1 and I too had this problem. My teacher told me it was probably because my MySQL server had stopped running. She told me to go into the Computer Management utility (right click the lower-most left hand corner of the screen on Windows 8.1 to access Computer Management). Then under Services and Applications, open up the Services and find MySQL. You should be able to right-click on MySQL and restart it.

In case of Xampp Installation.

Go to your xampp installation and mysql folder, for my case: C:\xampp\mysql

Run the file "resetroot.bat" from cmd or explorer.

My installation started working!!!

The main reason for this kind of error is you might have uninstalled Mysql server application. Install it and then give it a go.

The solution that fixed the issue was using the following steps:

In Start Menu, search for "mysql". Among the results, you should see the "MySQL Installer - Community". Run it. MySQL Installer window will show up as shown below. Find "MySQL Server" under Product and click on "Reconfigure" link. MySQL Installer Community

The MySQL Installer will show up (same one you used for the first MySQL Server installation). Go through all the steps.

After the MySQL Installer was finished, I started the MySQL service again.

I also faced the same issue and resolved it by below setups:

1. Check the MYSQL service in the windows service. If it is there and not running then start it. It will solve your problem.

   You can find the services window by navigating to windows Start menu and typing 'services' in the search bar. Select the 'Services' option with the cogs next to it (not the executable file) and the below window will appear. Scroll down to find 'MySql (version)'. When you select MySql you should see an option in the left pane that says 'Start the service'. Click this and a dialogue should appear to indicate Windows is attempting to start the service. Once started the left pane will now give you the option to stop, pause and restart the service and you will now be able to connect to your MySql from the windows cmd line.

2. If MYSQL service is not present in windows service then follow below setups.

   a. Open cmd as administrator.

   b. cd to C:\Program Files (x86)\MySQL\MySQL Server 5.6\bin

   c. Run the command: C:\Program Files (x86)\MySQL\MySQL Server 5.6\bin>mysqld.exe --install

   d. Check the MySql in the windows service, And if it is not running, Start it by clicking on the service.

   e. If your using XAMMP . Start MySQL at the XAMMP control Panel.