Navicat Error 10061
2016 03:44 Apply OS: Windows, Mac, Linux, iOS Apply Navicat Product: Navicat for MySQL, Navicat for MariaDB, Navicat Premium Apply Navicat Version No.: All 2003 - can't connect to mysql server on 'localhost' (10038) If you get the error message 'Can't connect to MySQL server 2003 can't connect to mysql server on 'localhost' (10061) on some_host', you can try the following things to find out what the problem is: Check whether the navicat can't connect to mysql server on localhost server is running on that host, e.g. in Windows, executing telnet some_host 3306 and pressing the Enter key a couple of times. (3306 is the default MySQL port number.
2003 Cannot Connect To Mysql Server On Localhost 10038Change the value if your server is listening to a different port.) If there is a MySQL server running and listening to the port, you should get a response that includes the server's version number. If you get an error such as telnet: Unable to connect to remote host: Connection refused, then there is no server running on the navicat error 2003 given port. If the server is running on the local host, try using mysqladmin -h localhost variables to connect using the Unix socket file. Verify the TCP/IP port number that the server is configured to listen to (it is the value of the port variable.) Make sure that your mysqld server was not started with the --skip-networking option. If it was, you will not be able to connect to it using TCP/IP. Check to make sure that there is no firewall blocking access to MySQL. Applications such as ZoneAlarm and the Windows XP personal firewall may need to be configured to allow external access to a MySQL server. For more information, please refer to - http://dev.mysql.com/doc/refman/5.1/en/can-not-connect-to-server.html Was this article helpful? 0 out of 0 found this helpful Facebook Twitter LinkedIn Google+ Have more questions? Submit Ticket. Have more questions? Submit a request 0 Comments Article is closed for comments. Related articles 1130 - Host xxx is not allowed to connect to this MySQL server 2013 - Lost Connection to MySQL server during query 200
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack mysql server download Overflow the company Business Learn more about hiring developers or posting ads with us
Mysql WorkbenchStack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a
Xamppcommunity of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Can't connect to MySQL server on 'localhost' (10061) (mainly remote connections) up vote 0 down https://help.navicat.com/hc/en-us/articles/217790698-2003-Can-t-connect-to-MySQL-server-on-xxx-10061- vote favorite Good day, firstly I'd like to sorry for my English. after installing latest WAMP I have problem with access to my MySQL server from remote machines in my LAN. It looks like it refuse tcp connections (before adding bind-address telnet localhost 3306 refuse tcp connections). My WAMP icon in tray is green, so all looks fine (even in my.ini after comparing to old version). My WAMPy is putted online. http://stackoverflow.com/questions/5013810/cant-connect-to-mysql-server-on-localhost-10061-mainly-remote-connections Apache has Rewrite module enabled if it is important. I have even firewall disabled. I use Free AVG (so I think it didn't block anything) When my coworkers want to connect, they get: mysql_connect():  trying to connect via tcp://my-pc:3306. When I try to use Navicat Lite, I get "Can't connect to MySQL server on 'localhost' (10061)" Previous all wamp services was disabled before installing new WAMPy. At home everything works fine but here I have third day lost ;/ C:\Documents and Settings\Administrator\Pulpit>mysqladmin -uroot -p version Enter password: ***** mysqladmin Ver 8.42 Distrib 5.5.8, for Win32 on x86 Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Server version 5.5.8-log Protocol version 10 Connection localhost via TCP/IP TCP port 3306 Uptime: 2 min 0 sec Threads: 1 Questions: 1 Slow queries: 0 Opens: 33 Flush tables: 1 Open tables: 26 Queries per second avg: 0.8 c:/wamp/bin/mysql/mysql5.5.8/my.ini content [client] port = 3306 socket = /tmp/mysql.sock [wampmysqld] port = 3306 socket = /tmp/mysql.sock key_buffer = 16M max_allowed_packet = 1M table_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M basedir=c:/wamp/bin/mysql/mysql5.5.8 log-error=c:/wamp/logs/mysql.log datadir=c:/wamp
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn http://stackoverflow.com/questions/25842341/2003-cant-connect-to-mysql-server-on-localhost-10038 more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, http://superuser.com/questions/377699/cant-connect-to-mysql-server-on-localhost-10061-but-can-via-php helping each other. Join them; it only takes a minute: Sign up 2003 - Can't connect to MySQL server on 'localhost' (10038) up vote 2 down vote favorite 1 I installed mysql server in my ubuntu virtual mysql server machine, then I use Navaicat for Mysql to connet mysql, but failed. Navicat for Mysql is installed on Windows 7, Navicat version is 11.0.10, enterprise edition mysql is installed in my virtual machine, the system is Ubuntu 12, when I connect the mysql server, it returns: my navicat connection configuration: I tried several methods, including use the command: grant all privileges on . to 'root'@'%' identifed by 'passwd' with grant option and I shutdown the firewall connect to mysql of ubuntu using: ufw disable and I hava also shutdown the firewall of windows 7, the state of port 3306 of the ubuntu server is: the iptable rules is like this: the mysql.user table is like this: but still, the navicat gives me the error: 2003 - can't connect to mysql server on 'localhost' (10038) anyone can help me? thank you! mysql ubuntu navicat share|improve this question edited Sep 15 '14 at 6:59 asked Sep 15 '14 at 6:53 mindcache 5043926 What you response you get, when you enter 192.168.3.164 in windows browser? Is it accessible IP address? –Justinas Sep 15 '14 at 7:05 it's the IP of my ubuntu viritual machine, my windows 7 IP is 192.168.3.133, so I can ping the ubuntu vm successfully –mindcache Sep 15 '14 at 7:07 the ubuntu is installed in the VritualBox of my windows system –mindcache Sep 15 '14 at 7:08 add a comment| 3 Answers 3 active oldest votes up vote 10 down vote accepted I solved this problem. In my /etc/mysql/my.cnf, the command bind the locahost address like this: bind-address=127.0.0.1, just add a # before it. and now I can connect to the mysql server smoothly. share|improve this answer answered Sep 18 '14 at 3:34 mindcache 5043926 add a comment| up vote 0 down vote Try add Port Forwarding
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Super User Questions Tags Users Badges Unanswered Ask Question _ Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Can't connect to MySQL server on 'localhost' (10061), but can via PHP up vote 4 down vote favorite With WAMP 2.2 serving Apache 2.2.21, MySQL 5.5.16 and PHP 5.3.8 on my Windows XP development machine, I can connect and manage my database via phpMyAdmin or any locally hosted PHP script using a DNS like "mysql:host=localhost;dbname=kwamjing" When I try to connect to MySQL via a management tool like HeidiSQL or MySQL Query Browser I get Error 2003 Can't connect to MySQL server on 'localhost' (10061) Can a firewall block HeidiSQL from accessing 127.0.0.1:3306 but not PHP? UPDATE: Looking at my active connections through netstat -an I see only the ipv6 loopback listening on 3306 Active Connections Proto Local Address Foreign Address State TCP 0.0.0.0:135 0.0.0.0:0 LISTENING TCP 0.0.0.0:445 0.0.0.0:0 LISTENING TCP 0.0.0.0:2869 0.0.0.0:0 LISTENING TCP 127.0.0.1:80 0.0.0.0:0 LISTENING TCP 127.0.0.1:1025 0.0.0.0:0 LISTENING TCP 127.0.0.1:2215 127.0.0.1:2216 ESTABLISHED TCP 127.0.0.1:2216 127.0.0.1:2215 ESTABLISHED TCP 127.0.0.1:2217 127.0.0.1:2218 ESTABLISHED TCP 127.0.0.1:2218 127.0.0.1:2217 ESTABLISHED TCP 127.0.0.1:5152 0.0.0.0:0 LISTENING TCP 192.168.0.103:139 0.0.0.0:0 LISTENING TCP 192.168.0.103:2869 192.168.0.1:4530 CLOSE_WAIT TCP 192.168.0.103:2869 192.168.0.1:4532 CLOSE_WAIT TCP [::]:135 [::]:0 LISTENING 0 TCP [::]:2869 [::]:0 LISTENING 0 TCP [::]:3306 [::]:0 LISTENING 0 mysql5 share|improve this question edited Jan 12 '12 at 17:40 asked Jan 12 '12 at 16:50 JannieT 43641326 check if you are able to telnet to 127.0.0.1:3306 –daya Jan 12 '12 at 17:00 telnet connection fials –JannieT Jan 12 '12 at 17:35 add a comme