Error 10060 Mysql
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: December mysql error 10060 can't connect 25, 2008 09:50PM Hello everyone, this problem is pretty simple to solve. If you're getting can't connect to mysql server 10060 error 10060, this means that you ARE NOT ALLOWED to access the web server remotely. Usually we (I mean, I) access the mysql
Mysql Error 2003
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 story is different.
Mysql Error 10061
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 use the domain name, mysql port 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 Re: ERROR 2003: Can't connect to MySQL server (10060)
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
Mysql Error 1130
Overflow the company Business Learn more about hiring developers or posting ads with us 10060 mysql error code Server Fault Questions Tags Users Badges Unanswered Ask Question _ Server Fault is a question and answer site for system and network cannot connect to mysql server 10061 administrators. 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 Remote MySQL http://forums.mysql.com/read.php?34,49742,239961 connection fails (10060) up vote 7 down vote favorite 4 When I am trying to connect to a MySQL database from a remote 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 http://serverfault.com/questions/137418/remote-mysql-connection-fails-10060 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 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 Ta
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and http://stackoverflow.com/questions/37198952/workbench-error-10060-while-connecting-to-mysql-aws-rds-instance policies of this site About Us Learn more about Stack Overflow the company Business Learn 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 4.7 million programmers, just like you, helping each other. Join them; it only takes mysql error a minute: Sign up workbench error 10060 while connecting to Mysql AWS RDS instance up vote 0 down vote favorite I have set up a mysql RDS instance which accepts connection from anywhere within our organization. I have set up an user for this instance as well. Few days back user complained that workbench can not connect to this instance and connect to mysql getting the error : Lost connection to MySQL server at 'waiting for initial communication packet', system error: 10060 It used to work for him, but all of a sudden it stopped working. Not sure what user has done between when it worked and now. Anyways, I have done the following troubleshooting steps: 1. did telnet 'rds end point' 3306 from this terminal and noticed connection is there 2.I tried to connect to this instance from my machine using workbench, heidisql and mysql cmd prompt utilities...every time it works 3.reset his password (just for trying)see attached, but problem persists Thoughts? workbench version is 6.1 CE and user is on windows 7 mysql amazon-web-services mysql-workbench amazon-rds share|improve this question edited Aug 8 at 19:57 Kara 3,12973147 asked May 12 at 23:18 Suvro Choudhury 111 Did you troubleshoot his machine or yours? –Tim Biegeleisen May 12 at 23:21 I troubleshoot his machine making sure he has connectivity to RDS instance by telnet. I also connected from my machine using his credentials to make sure his credentials are valid. –Suvro Choudhury