Can t connect to MySQL server on localhost 10061

Question

I recently installed MySQL 5 on Windows 2003 and tried configuring an instance  Everything worked fine until I got to  Applying Security settings   at which point it gave me the above error  Can t connect to MySQL server on  localhost   10061     I do have a port 3306 exception in my firewall for  MySQL Server

User · Answer

English     press Windows   R write  services msc   Then press Enter search for  MySQL57 and right click click on  start the service   Fran  ais     Appuyez sur la touche Windows   R   crire  services msc  Puis appuyez sur Entr  e Recherchez MySQL57 et clic droit Cliquez sur r  d  marrer

User · Answer

Got this error on Windows because my mysqld exe wasn t running    Ran  C  Program Files MySQL MySQL Server 5 5 bin mysqld  --install from the command line to add it to my services  ran services msc  start -  run   found the MySQL service and started it    Didn t have to worry about it from there on out

User · Answer

To connect locally to MySql  you do not have to setup a firewall with inbound rules  But  even if you already setup iptables to allow the TCP inbound port 3306 and grant the privilege to the user to access the db locally  you may have to setup the bind address in your my cnf file  edit the default address there and put the server IP address that is running the MySql service

User · Answer

press Windows key   R write  services msc  enter search for  MYSQL56  write click on it and start the service

User · Answer

I had difficulty accessing MySQL while connecting via a localhost connection on the standard port 3306  which worked fine when I installed and configured it for prior classes I had taken in MySQL and Java  I was getting errors like  error 2003  and  Cannot connect to MySql server on localhost  10061    I tried connecting from both MySQL Workbench  5 2 35 CE  and Netbeans  7 2   I am using Windows 7 64 bit professional    I tried typing in services msc in the start menu search box  which opened the services dialog box to show all the services installed in windows  I scrolled down to MySQL and started this service  Subsequent attempts to connect to MySQL from MySQL WorkBench and from the command prompt succeeded

User · Answer

To resolve this problem    go to the task manager select Services tab find MySql service Running   That s all

User · Answer

Edit your  my-default ini  file  by default it comes with commented properties as below ie   basedir D  D Drive mysql-5 6 20-win32 datadir D  D Drive mysql-5 6 20-win32 data port 8888   There is very good article present that dictates commands to create user  browse tables etc ie   http   www ntu edu sg home ehchua programming sql MySQL HowTo html zz-3 1

User · Answer

run  gt  services msc  gt  rightclick MySQL57  gt  properties  gt set start type option to automatic   after restarting computer  At cmd  cd  C    C    gt  cd  C  Program Files MySQL MySQL Server 5 7 bin    it will become  C  Program Files MySQL MySQL Server 5 7 bin gt    type mysql -u root -p  ie C  Program Files MySQL MySQL Server 5 7 bin gt  mysql -u root -p  Enter password        That s all  It will result in  mysql gt

User · Answer

I got this error when I ran out of space on my drive

User · Answer

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

User · Answer

Right click on My Computer  Click on Manage Go to Services and Application Select Services and find MySQL service Right click on MySQL and select Start

User · Answer

You ll probably have to grant  localhost  privileges to on the table to the user   See the  GRANT  syntax documentation   Here s an example  from some C source        GRANT ALL PRIVILEGES ON  s   TO   s   localhost  IDENTIFIED BY   s      That s the most common access problem with MySQL   Other than that  you might check that the user you have defined to create your instance has full privileges  else the user cannot grant privileges   Also  make sure the mysql service is started   Make sure you don t have a third party firewall or Internet security service turned on   Beyond that  there s several pages of the MySQL forum devoted to this  http   forums mysql com read php 11 9293 9609 msg-9609  Try reading that

User · Answer

Make sure that your windows host file  located at c   windows system32 drivers etc host  has following line  If not  add it at the end  127 0 0 1 localhost   1 localhost  Sometimes mysql can not trigger Windows to force start host services if firewall blocks it  so start it manually    win run  services msc  select the  MySQL xx  where  xx  is the name you have assigned to MySQL host services during setup  Click on  start  to start from hyperlink appeared on left side

User · Answer

Nothing to do just  Reset to Default  your firewall setting it will start working   I read many solutions but nothing worked properly  so at last I reset firewall settings which worked

User · Answer

finally solved this   try running mysql in xammp  The check box of mysql in xammp should be unclicked  then start it  after that you can open now mysql and it will now connect to the localhost

User · Answer

Another possibility   There are two ways the MySQL client can connect to the server  over TCP IP  or using sockets   It s possible you have your MySQL server configured to support socket connections  but not network connections

User · Answer

I tried Kuzhichamadam Inn s solution and found that a slight change needed to be made   MYSQL57 was a network service   I had tried this repeatedly with no success   When I opened services msc I found another service for localhost   MySQL   I started that one using the process below and it worked   run   services msc   rightclick MySQL   properties  start

User · Answer

Since I have struggled and found a slightly different answer here it is   I recently switched the local  intranet  server at my new workplace  Installed a LAMP  Debian  Apache  MySql  PHP  The users at work connect the server by using the hostname  lets call it  intaserv   I set up everything  got it working but could not connect my MySql remotely whatever I did   I found my answer after endless tries though  You can only have one bind-address and it cannot be hostname  in my case  intranet    It has to be an IP-address in eg   bind-address 192 168 0 50

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

Examples related to mysql

Examples related to localhost

Examples related to mysql5

Examples related to windows-firewall