Navicat Error 10060
Contents |
Community Podcasts MySQL.com Downloads Documentation Section Menu: MySQL Forums :: MySQL Administrator :: ERROR 2003: Can't connect to MySQL server (10060) New Topic Advanced Search Solution to Connecting remotely when you get Error 10060 Posted by: Mohamed Infiyaz Zaffer Khalid () Date: cannot connect to mysql server on localhost 10060 December 25, 2008 09:50PM Hello everyone, this problem is pretty simple to solve. If cannot connect to mysql server 10061 you're getting error 10060, this means that you ARE NOT ALLOWED to access the web server remotely. Usually we (I mean, I) access aws mysql 10060 the mysql databases using php and this is on the SAME server. Thus we use 'localhost' to connect. But if you were to for example access the same web database using a local machine running VB, the
2003, Can't Connect To Mysql Server On (10060)
story is different. First, here's what you should NOT do. I'm saying this because I noticed some responses had these as action steps. So, 1. DON'T change any ports 2. DON'T close existing ports and reopen new ones as it may affect other apps. 3. DON'T disable any firewalls. Now here's what you MUST do: 1. on your connection string, make sure that you're using the SERVER'S correct IP. On the other hand, you can mysql workbench connection error 10061 use the domain name, and this is what I do. 2. The rest of the parameters are the same. I mean they're what you want or have set. 3. NOW the critical thing. First you've got to tell your web server that you need to accept remote connections. You can easily do this using the cpanel. When you're asked for the remote host name, type in % (the percentage sign) to mean ANY HOST. 4. Finally, you may have to tell the web server's firewall that you're making a remote connection from your machine. To do this, cpanel allows you to add your own IP into a 'white list'. In most cases, cpanel shows you a list of class C IPs and your one should be there. Select it. Save the settings. Now go into your app and run the program - eg: in VB. Should work just fine! Happy coding. Khalid ================================== The Smart Solutions Expert PHP MySQL Javascript VB6 C/C++ http://www.marhaonline.com Edited 1 time(s). Last edit at 12/25/2008 09:53PM by Mohamed Infiyaz Zaffer Khalid. Navigate:Previous Message•Next Message Options:Reply•Quote Subject Written By Posted ERROR 2003: Can't connect to MySQL server (10060) yanfangguo 10/17/2005 08:32AM Re: ERROR 2003: Can't connect to MySQL server (10060) Douglas Hardy 11/05/2005 12:48PM Re: ERROR 2003: Can't connect to MySQL server (10060) Douglas Hardy 11/05/2005 01:21PM
Start 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 cannot connect to mysql server on localhost 10061 windows 7 ads with us Server Fault Questions Tags Users Badges Unanswered Ask Question _ Server Fault is a
Mysql Cpanel
question and answer site for system and network administrators. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask
Error 2003 Can't Connect To Mysql Server On 'localhost' (10061)
a question Anybody can answer The best answers are voted up and rise to the top Remote MySQL connection fails (10060) up vote 7 down vote favorite 4 When I am trying to connect to a MySQL database from a remote http://forums.mysql.com/read.php?34,49742,239961 computer I get a prompt saying: Connection Failed: [HY000] [MySQL][ODBC 5.1 Driver]Can't Connect to MySQL server on 'XXX.XXX.XX.XX' (10060) I have created a user account in the MySQL Administrator and added a host to enable remote access, I have also made an exception for my Windows Firewall on port 3306 but the connection still fails. What is the problem? Thanks! mysql remote-access odbc share|improve this question asked Apr 30 '10 at 12:41 migrated from stackoverflow.com Apr 30 '10 at 14:23 This question came from http://serverfault.com/questions/137418/remote-mysql-connection-fails-10060 our site for professional and enthusiast programmers. 1 Not a programming related question, but anyway, check if the remote computer is able to connect to any other service running on the same computer you're running the MySQL server. I doubt it is however. Very likely to be a NAT problem. –jweyrich Apr 30 '10 at 12:51 @jweyrich: You were very right, the ISP have blocked all ports but 21, 80 and 3389. –Anonymous May 1 '10 at 9:12 add a comment| 7 Answers 7 active oldest votes up vote 3 down vote I suppose your mysql server is running on Windows...thus open a DOS window and type: netstat -an You should find a row like this: TCP 0.0.0.0:3306 0.0.0.0:0 LISTENING This tell you that mysql server is running and listening on TCP port 3306. Another test you can do is to telnet (from another pc) to your mysql server: telnet ip_mysql_server 3306 This should open a telnet session: Connected to server_name. Escape character is '^]'. 5.0.XX-community-nt-log share|improve this answer edited Sep 8 '15 at 5:48 TallTed 19917 answered Apr 30 '10 at 14:35 lg. 2,94521318 Thanks for this, I tried connection to the server from the remote computer using "telnet ip_mysql_server 3306" but the connection fails. –Anonymous Apr 30 '10 at 16:02 Maybe this seems a stupid question but...is running mysql server? Which is the result of netstat? –lg. May 3 '10 at 8:44 add a comment| up vote 2
Best Blogs Blog List Search Blogs elitepvpers > Conquer Online 2 > CO2 Main - Discussions / Questions Help about socket error 10060 You last visited: Today at 03:30 http://www.elitepvpers.com/forum/co2-main-discussions-questions/44927-help-about-socket-error-10060-a.html Search Forums Show Threads Show Posts Tag Search Advanced Search Find All Thanked Posts Search Blogs Tag Search Advanced Search Go to Page... Please register to post and access all features, it's quick, easy http://forums.devart.com/viewtopic.php?t=9002 and FREE! Help about socket error 10060 11/27/2005, 02:37 #1 korniks elite*gold: 0 The Black Market: 0/0/0 Join Date: Aug 2005 Posts: 102 Received Thanks: 4 hey guys.. i just connect to wanna ask if an1 had a knowledge on working on routers.. coz the issue about socket error 10060 everytime u run the game pops out.. i tried connecting my internet connection to my main computer and conquer works.. now that i tried connecting my internet wid a router it doesn't wanna work anymore and gives me that socket error 10060.. an1 can help wid this matter? or an1 had a connect to mysql problem like this and got it fix.. btw conquer works well wid the router before.. now i dunnot wat happened 11/27/2005, 03:07 #2 Soulwinter elite*gold: 0 The Black Market: 0/0/0 Join Date: Nov 2005 Posts: 561 Received Thanks: 27 did u reset ur router or sorta stuff? 11/27/2005, 16:12 #3 n0obh4x0r elite*gold: 0 The Black Market: 0/0/0 Join Date: Nov 2005 Posts: 210 Received Thanks: 2 your internet connection probably wasn't connected correctly, try to shut down your computer, reset your router wait 5 mins and reboot your computer. 11/27/2005, 18:57 #4 chocoman4k elite*gold: 0 The Black Market: 0/0/0 Join Date: Apr 2005 Posts: 689 Received Thanks: 212 Did you set the correct MTU at the router? Try to visit microsoft.com, if it loads very slowly or not at all your MTU is probably wrong. You can get the correct MTU from your ISP's homepage or customer service. 11/27/2005, 20:10 #5 pakelika elite*gold: 0 The Black Market: 0/0/0 Join Date: Nov 2005 Posts: 2 Received Thanks: 0 I am having the same problem, but there is a fix for it that works for me, i dont know much about the MTU, i am using
a reply 11 posts • Page 1 of 1 Socket error on connect. WSAGetLastError return 10060($274C) by iad » Wed 24 Jan 2007 23:39 Hi, Thanks for the help so far, i getting annoyed by Socket error on connect. WSAGetLastError return 10060($274C) error all the time, this is happening on Scrip execute and Query execute and what is interesting is that it happened only in procedure that calling to two MySQL servers one after one. it happpenning several clients spreading around, i set the time out to 60 seconds, but it still keep coming. just must say that when i;'m using different MySQL component , i don;t get any error, something i'm doing wrong ? Lior, iad Posts: 34Joined: Fri 24 Nov 2006 07:38 Top by iad » Wed 24 Jan 2007 23:44 and one more thing, i measured the time it take for the spitting the error, it 11-21 seconds, the the 60sec timeout i set should be intact ? iad Posts: 34Joined: Fri 24 Nov 2006 07:38 Top by Antaeus » Thu 25 Jan 2007 07:53 Thank you for information. Unfortunately we could not reproduce the problem. Please send a complete small sample to evgeniyD*crlab*com to demonstrate it, including script to create and fill table(s). Also supply us the following information - Exact version of Delphi, C++ Builder or Kylix - Exact version of MyDAC. You can see it in the About sheet of TMyConnection Editor - Exact version of MySQL server and MySQL client. You can see it in the Info sheet of TMyConnection Editor Antaeus Posts: 2098Joined: Tue 14 Feb 2006 10:14 Top by Antaeus » Thu 25 Jan 2007 09:02 Probably there is something wrong with your network. Please check settings of your proxy, firewall, antivirus software, etc. Does the problem appear if the second server is located on localhost? Antaeus Posts: 2098Joined: Tue 14 Feb 2006 10:14 Top by iad » Thu 25 Jan 2007 19:35 Hi, i thing i manage to fix it by setting the pooling to True. i wonder why .... ? i have a new problem now, the MYSQL server is crashing one a day when using SSL, strange .... any lead ? Lior, iad Posts: 34Joined: Fri 24 Nov 2006 07:38 Top by Antaeus » Fri 26 Jan 2007 12:14 i thing i manage to fix it by setting the pooling to True.i wonder why .... ? It is good to see that this problem has been solved.Probably the reason of this proble