ERROR 2003 HY000 Can t connect to MySQL server on localhost 10061

Question

I installed  MySQL on Microsoft Windows 8 Using a noinstall Zip Archive  But when i tested by executing the following commands on windows prompt  the above error showed up   C   gt   C  MySQL bin mysqlshow    C   gt   C  MySQL bin mysql  test   Please help me

User · Answer

I faced the same problem couple of times and each time the reason was different    The solution that worked first time was that by  Abhishek Oza  which is same as that of  amey91   see above  The second time  my server was on a different port number than the default one 3036  so i was not able to connect So I had to specify the port number explicitly for making the connection which you can do simply by writing   mysql --host 127 0 0 1 --port 8081 specify your port number here  mysql -u root -p

User · Answer

I had a problem with most of these solutions   The fact that I couldn t find the bin folder in my c drive  I tried solution offered here    https   www howtosolutions net 2017 08 fixing-mysql-10061-error-after-migration-of-database-files    and vwala  welcome to the mysql monitor

User · Answer

i also face the same problem  try it   Go to bin directory copy the path and set it as a environment variable  Run the command prompt as admin and cd to bin directory   Run command   mysqld    install Now the services are successfully installed Start the service in service windows of os Type mysql and go

User · Answer

I will advise to use first check if my ini exist in mysql folder in c drive or in windows folder mysqld -install  Service successfully installed  mysqld --initialize  no prompt  Also another advise is not to use mysql 8  since it is not compatible with wordpress or any other opensource yet  there are lot of changes between version 5 and version 8  so if you are using mysql please use version 5 x

User · Answer

Well that could have some reasons   THe first one is that the MySQL server service not started   If he is started you should check out the logfiles  and make sure there are no problems   You could also uninstall the MySQL service and install XAMPP  With XAMPP it is easier to manage this services

User · Answer

Go to Run type services msc  Check whether MySQL services is running or not  If not  start it manually

User · Answer

I had the same problem  I tried all of the answers above  and some from other websites   In the end  my issue was that my cache wasn t configured  I found that info in my error log and fixed it by changing the line in the file    C  MAMP bin apache conf extra http-ssl conf  There I removed the double quotes from the line    SSLSessionCache         shmcb  some example path ssl scache 512000    to   SSLSessionCache        shmcb  some example path ssl scache 512000   and saved with Ctrl S and closed the file   Here s the link that helped me   https   wiki apache org httpd SSLSessionCache

User · Answer

Had this issue in Windows 10 and MySQL 8  Resolved by following steps  Searchbar bottom left    Task Manager   Run as administrator   Services   MySQL80

User · Answer

This happened to me too  But I accidentally found out that execute the  mysqld  command can solve your problem    My SQL version is 5 7  Hope this works for you

User · Answer

Hey this is not a big issue what you need to do is       1  Run your cmd as administrator   2 What you will see is like this c  windows system32 gt   3 Go to your bin location by using cd   like C  mysql bin my location of bin in my computer is what you are seeing so chose yours correctly   4 C  mysql bin gt mysql --install   Service successfully installed   5 C  mysql bin gt NET START MySql  The MySql service is starting  The MySql service was started successfully   Then last step is  6 C  mysql bin gt mysql -u root - p admin It will ask for password don t enter anything first time because it will use blank  n just press enter you are done    N later you can set password too

User · Answer

First of all  you need to ensure the port number on which the server is running  Then you can run   mysql -u username -p --port portNumber on the command line

User · Answer

Go to Run type services msc  Check whether MySQL services is running or not  If not  start it manually  Once it started  type mysqlshow to test the service

User · Answer

I have a windows 8 1 machine and mysql was not running at all even after trying to start mysqld with no error logs  This solution worked for me    start cmd in admin mode type in  net start mysql  close current cmd window and open new cmd window type in  mysql    The mysqld service should now be available

User · Answer

I was stuck on this same issue for what felt like an eternity   My problem was  I was running mysql from MAMP on port 8889  but when trying to connect to mysql from my command line  it was expecting port 3306  I was running out of ideas  so I tried   mysql --port 8889  and happiness ensued   Welcome to the MySQL monitor   Commands end with   or  g  Your MySQL connection id is 2 Server version  5 6 34-log MySQL Community Server  GPL

User · Answer

Though it is an old question  I am adding my answer in it  because the solution that worked for me on Windows 7 as an admin user  is missing in the answers  list  Though my solution is for installed MySQL  I am putting it for those who search for a solution for this error message  Here it is  Click on the Windows 7 start button and type taskmgr in the search bar  Right click on the taskmgr program icon and select Run as administrator In the Task Manager window  go to the Services tab Right click on the MySQL service and click Start Service

User · Answer

In my case I have 2 different version of mysql in Windows OS and I solved the my problem by bottom step  first stop all mysql service  I create one config file in C  mysqldata cnf with bottom data my mysql is in  quot C  mysql-5 0 96-winx64 quot  directory     mysqld  datadir   C  mysql-5 0 96-winx64 data port   3307  then I run bottom command in cmd  C  mysql-5 0 96-winx64 bin mysqld --defaults-file C  mysqldata cnf --console  above step reference then I create txt file in C  resetpass txt with bottom data  UPDATE mysql user SET password PASSWORD  ttt   WHERE user  root    then run mysqld with bottom command  C  mysql-5 0 96-winx64 bin mysqld --init-file C  resetpass txt --install mysql2 --console net start mysql2  after these step you have one mysql service with name mysql2  than run with port 3307  I have 2 version of mysql with different user management tables in version 5 0 96 user table difference with 5 5 version because of that I must be change table folder in first step  you can run other mysql service with other port now and you can run this steps with different datadir  service name and port for it again

User · Answer

In my case  which was a manual install using the  zip file  I solved this by specifying the nonstandard MySQL and Data install locations in a my ini  https   dev mysql com doc refman 8 0 en windows-create-option-file html  Then I needed to run the data directory initialisation commands  https   dev mysql com doc refman 8 0 en data-directory-initialization-mysqld html  Then running  net start mysql

User · Answer

Despite that my server was running  I had the same problem  I found out that it was the port  So you need to specify the port  mysql -u user -p --port 0000  The port on your machine may be different  To find out on which port mysql is running open the mysql ini file and look for port   A port often used is 3306  Example how to log on to mysql mysql -u root -p --port 3306

User · Answer

First make sure you have installed MYsql Sqlyog if you are using it       Start Registry Editor  Regedt32 exe       Locate the following key in the registry  HKEY LOCAL MACHINE SYSTEM CurrentControlSet Services Tcpip Parameters On the Edit menu  click Add Value  and then add the following registry value     Value Name  MaxUserPort    Data Type  REG DWORD    Value  65534  This sets the number of ephemeral ports available to any user  The valid range is between 5000 and 65534  decimal   The default value is 0x1388  5000 decimal   On the Edit menu  click Add Value  and then add the following registry value     Value Name  TcpTimedWaitDelay    Data Type  REG DWORD    Value  30  This sets the number of seconds to hold a TCP port connection in TIME WAIT state before closing  The valid range is between 30 and 300 decimal  although you may wish to check with Microsoft for the latest permitted values  The default value is 0x78  120 decimal   Quit Registry Editor   Reboot the machine

User · Answer

You don t need to restart your windows  The easiest way to achieve this is    Goto  bin  Run mysqld  service  close the cmd prompt Run mysql exe or the better way to do is add the location to PATH environment Variable   Thanks

User · Answer

If you re using the no install zip  you need to execute mysqld exe first to start the service  and then execute mysql exe to open your connection    The no install is nice  but if you intend to do any serious work with MySQL  you may want to consider either using the MSI to do a proper installation  or if you re doing web development work give XAMPP a try

User · Answer

Check Mysqld exe file is in your bin folder  if it is not there   just copy that file from any other computer and paste it on your bin folder Just double click  Then run mysql its solved

User · Answer

Test if the server is running  You can use netstat for this  See https   serverfault com questions 260239 unable-to-connect-to-mysql-through-port-3306   If it is running  it may be the firewall  You can turn that off to test if that is the problem    See the following manual to install Mysql as a service  https   dev mysql com doc refman 5 5 en windows-start-service html

User · Answer

I have tried all the above mentioned options but can not find the solution to this problem   Then I got its solution     This error is flashed when we are trying to open mysql with out stating the service  Follow the bellow mentioned steps   STEP 1 Open cmd prompt to start the service type  mysqld --console this will start the mysql service enter image description here STEP 2 dont close this cmd prompt now open new cmd prompt and  type mysql -u root -p  then enter ur passwordenter image description here

User · Answer

There is a possibility that your installation of MYSQL got corrupted  The best thing you can do is to search for MYSQL INSTALLER on your system and then run it again   It will not download the mysql server again  it will just help you to set it up   After that  edit your environment variables path and add the bin folder of your mysql to it    By now  it should work

User · Answer

The solution that worked for me is   Downloaded mysql-8 0 22-winx64 zip file Extracted the zip file Moved the extracted folder to C  Program Files Opened cmd exe as admin Navigated to the directory cd C  Program Files mysql-8 0 22 mysql-8 0 22-winx64 bin mysqld -install  Service successfully installed  mysqld --initialize  no prompt  Opened services msc Found MySQL Right-click and start  Let me know if it helps

[mysql] ERROR 2003 (HY000): Can't connect to MySQL server on localhost (10061)

Examples related to mysql