10060 Mysql Error
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 10060 mysql error code by: Mohamed Infiyaz Zaffer Khalid () Date: December 25, 2008 09:50PM Hello everyone, mysql error 10060 can't connect this problem is pretty simple to solve. If you're getting error 10060, this means that you ARE NOT ALLOWED to
Can't Connect To Mysql Server 10060
access the web server remotely. Usually we (I mean, I) access the mysql databases using php and this is on the SAME server. Thus we use 'localhost' to connect. But if you were to
Mysql Error 2003
for example access the same web database using a local machine running VB, the 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 mysql error 10061 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, 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:Re
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
Mysql Port
Learn more about hiring developers or posting ads with us Server Fault Questions Tags Users mysql error 1130 Badges Unanswered Ask Question _ Server Fault is a question and answer site for system and network administrators. Join them; it only takes mysql workbench error 10060 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 connection fails (10060) up vote 7 down vote http://forums.mysql.com/read.php?34,49742,239961 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 3306 but the connection still fails. What is the problem? Thanks! mysql http://serverfault.com/questions/137418/remote-mysql-connection-fails-10060 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 TallTed 19917 answered Apr 30 '10 at 14:35 lg. 2,94721318 Thanks for this, I tried connection to the server from the remote c
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the http://stackoverflow.com/questions/17155665/cant-connect-to-mysql-database-using-external-ip-address 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 Stack Overflow Questions https://mindplay.desk.com/customer/portal/articles/1204988-no-connection-to-user-db-can-t-connect-to-mysql-server 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. mysql error Join them; it only takes a minute: Sign up can't connect to MySQL database using external ip address up vote 0 down vote favorite I have a MySQL server running on my Windows 7 computer as a Windows Service. When I try to connect to it using external.ip = my ip address from http://www.whatismyip.com/ in command prompt: mysql -h 10060 mysql error external.ip -u root -p it returns: ERROR 2003 (HY000): Can't connect to MySQL server on external.ip (10060) I can, however, connect it to it when I change external.ip to the ip address listed with the ipconfig command: mysql -h ipconfig.ip -u root -p I already changed the permissions for root to accept any host (using commands like those from Accessing a mysql database from external host/ip? (ie: mysql workbench)). In the database: SELECT host, user FROM user; returns (to summarize): | host | user | ----------------- | % | root | Also, in my my.ini file, there is no line that says skip-networking. It worked fine when I tried this the other day on a different network where external.ip was the same as ipconfig.ip. Could this be the source of the problem or is there something else? mysql database-connection ip-address ipconfig share|improve this question asked Jun 17 '13 at 19:54 xgord 1,6821027 I'll just assume you know that having root accessible to the world is a bad idea. Check your firewall. If whatsmyi
Reading Coach (MRC) is a server based program that was launched in 1998 and will have its life cycle ended in 2015. MindPlay has discontinued selling MRC and Technical support for MRC will endDecember 31, 2015. You may continue to use the MRC product, but technical support, lost disks, reimaged computers, lost licenses, etc. will no longer be supported. For information about the new cloud-based version, MindPlay Virtual Reading Coach (MVRC), launched in 2012, is available atwww.mindplay.com. Thank you. "No connection to user DB...Can't connect to MySQL server..." Applicable Versions and Operating Systems This Article applies to the following Program Versions and Operating Systems: Versions My Reading Coach Platinum (1.x, 2.x) My Reading Coach Gold (1.x, 2.x, 3.x) RAPS (1.0, 3.x) Operating Systems Windows Millennium, Windows 2000, Windows XP, Windows Vista, Windows 7 -------------------------------------------------------------------------------- Symptoms When the program launches, instead of asking to select the class or school, a message comes up saying "No connection to User DB. [MySQL][ODBC 3.51 driver] Can't connect to MySQL server on '(server name or IP address)' (10060)". Unless the error includes "Can't connection to MySQL server", then this is article does not apply to the issue you are experiencing. Please check for other articles that contain the error you are getting. -------------------------------------------------------------------------------- Causes Network connectivity issues This error means that the program was unable to connect to the MySQL service running on the specified computer. The first thing to check is that the workstations that have the program can connect to the server; especially if the program was working before. -------------------------------------------------------------------------------- MySQL service not running The workstation may be able to connect to the server, but the MySQL service is not running on the server. ------