Can t connect to MySQL server on localhost 10061 after Installation

Question

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

User · Answer

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.

User · Answer

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

User · Answer

Create the temp folder c  mysqltmp In my ini file under  mysqld  add the line  tmpdir c  mysqltmp Add full privileges to user NETWORK SERVICE for  C  ProgramData MySQL MySQL Server X Y Data ibdata1  file Start service   These are steps for the same problem with MySQL5 7 and MySQL8 0 on Windows 10

User · Answer

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

User · Answer

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

User · Answer

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 gt mysqld -install Service successfully installed   D  tools mysql-8 0 17-winx64 bin gt mysqld --initialize D  tools mysql-8 0 17-winx64 bin gt net start mysql The MySQL service is starting    The MySQL service was started successfully

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

This saved my life   mysqld --tc-heuristic-recover ROLLBACK   Read more

User · Answer

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  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  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

User · Answer

I solved this by adding the following arguments to the command line string   mysql --user username --password password --host localhost --port 3306 databasename  lt   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

User · Answer

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

User · Answer

In Windows 7   press Windows R it opens Run Enter services msc Find out mysql right click and start if mysql was not found   Run cmd as administrator goto C  Program Files  x86  MySQL MySQL Server 5 6 bin directory to go back use cd    and type mysqld exe --install   follow step 3   That s all

User · Answer

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  gt  MySQL  gt  start  If it fails to restart  then you can follow these steps      open the command line as an administrator    cmd exe  gt  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

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

I also faced the same issue and resolved it by below setups    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       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

User · Answer

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

User · Answer

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

User · Answer

if it is showing error 2003  HY000   Can t connect to MySQL server on localhost  10061  than    Search services msc in run  goto mysql properties  copy the mysql service name  start cmd as administrator  write  net start mysqlservicename  i e mysql57 or etc it will show mysql is starting

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

press Windows R it opens Run then   Enter services msc  then Find out mysql right click and start  it works

User · Answer

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

User · Answer

this issue is very to solve by windows server users   go to this path C  Program Files MySQL MySQL Server 5 1 bin run this tool  MySQLInstanceConfig exe    and config the instatnce again and problem solved

User · Answer

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

User · Answer

Please Try the following steps    c  mysql bin mysqld --install c  mysql bin mysqld --initialize   then press  Windows key   R  write  services msc   run as admin  start MySQL service

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

Examples related to mysql

Examples related to windows

Examples related to windows-7