Error 10060 Navicat
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 25, 2008 09:50PM Hello navicat error 2003 everyone, this problem is pretty simple to solve. If you're getting error 10060, this means that navicat 10060 hatası çözümü you ARE NOT ALLOWED to access the web server remotely. Usually we (I mean, I) access the mysql databases using php and this is cannot connect to mysql server on localhost 10060 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. First, here's what you should NOT do.
Cannot Connect To Mysql Server 10061
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, and this is what I do. 2. The rest of the 2003 - can't connect to mysql server on (10060) 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) Spyros Papantoniou 11/24/2005 09:44AM Re: ERROR 2003: Can't connect to MySQL server (10060) Michael Kay 12/14/2005 10:40AM Error in connecting to server..
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 aws mysql 10060 About Us Learn more about Stack Overflow the company Business Learn more about
Cannot Connect To Mysql Server On Localhost 10061 Windows 7
hiring developers or posting ads with us Server Fault Questions Tags Users Badges Unanswered Ask Question _ Server Fault is
Mysql Workbench Connection Error 10061
a 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 a question Anybody can answer The best http://forums.mysql.com/read.php?34,49742,239961 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 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 http://serverfault.com/questions/137418/remote-mysql-connection-fails-10060 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 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
Du siehst YouTube auf Deutsch. Du kannst diese Einstellung unten ändern. Learn more You're viewing YouTube in German. You can change this preference below. Schließen Ja, ich möchte sie behalten Rückgängig machen Schließen Dieses Video ist nicht verfügbar. https://www.youtube.com/watch?v=GlE4I-SlzRQ WiedergabelisteWarteschlangeWiedergabelisteWarteschlange Alle entfernenBeenden Wird geladen... Wiedergabeliste Warteschlange __count__/__total__ 2003 - Can't connect to http://stackoverflow.com/questions/12349948/cannot-connect-to-remote-mysql-with-vb6-10060 MySQL (FIX!) Misterblacjack AbonnierenAbonniertAbo beenden2121 Wird geladen... Wird geladen... Wird verarbeitet... Hinzufügen Möchtest du dieses Video später noch einmal ansehen? Wenn du bei YouTube angemeldet bist, kannst du dieses Video zu einer Playlist hinzufügen. Anmelden Teilen Mehr Melden Möchtest du dieses Video melden? Melde dich an, um unangemessene Inhalte zu connect to melden. Anmelden Statistik 43.267 Aufrufe 58 Dieses Video gefällt dir? Melde dich bei YouTube an, damit dein Feedback gezählt wird. Anmelden 59 17 Dieses Video gefällt dir nicht? Melde dich bei YouTube an, damit dein Feedback gezählt wird. Anmelden 18 Wird geladen... Wird geladen... Wird geladen... Die Bewertungsfunktion ist nach Ausleihen des Videos verfügbar. Diese Funktion ist zurzeit nicht verfügbar. Bitte versuche es connect to mysql später erneut. Veröffentlicht am 19.11.2012Easy Simple Done.This is if mysql is having issues if its not then this vid is not for you but if it is this is the right place pm if you have any questions.1. Get xamp.2. Get navicat (or any sql gui editor) 3. Install mysql within xamp (press the box next to it if its cross off red click to make it green)4. Click start on xamp to active it.5. Everything should be working. Kategorie Praktische Tipps & Styling Lizenz Standard-YouTube-Lizenz Mehr anzeigen Weniger anzeigen Wird geladen... Anzeige Autoplay Wenn Autoplay aktiviert ist, wird die Wiedergabe automatisch mit einem der aktuellen Videovorschläge fortgesetzt. Nächstes Video How to remove error number 2003 on mysql server - Dauer: 3:46 Irfan Ahmad Ganie 4.310 Aufrufe 3:46 Tutorial - Como resolver ERROR no MySQL "Can't connect to MySQL server on 'localhost' " - Dauer: 3:04 NappaPlayer 57.915 Aufrufe 3:04 Installing MySQL Server on Windows - Dauer: 14:12 Clever Techie 53.987 Aufrufe 14:12 Installing MySQL on Windows PC and Configuring it [[Solved] Error : Unable to Configure Service !!] - Dauer: 11:56 Nizam LZ 38.474 Aufrufe 11:56 M
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 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 a minute: Sign up Cannot connect to remote MySQL with VB6 (10060) up vote 1 down vote favorite 1 I got a hosting plan from GKG.net and I have a VB6 connection string to remotely reach MySQL database in it. I followed all instructions and tutorials about how to reach MySQL server remotely. Everything was fine till i get an error that says: [MySQL][ODBC 3.51 Driver] Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (10060) I searched for a solution over the net for hours but still there is nothing makes sense about it.. I double checked my connections.. I can ping to my static ip, but cant reach the MySQL server in it. From CPanel i can reach my db with phpMyAdmin. I tested my db and there was nothing wrong with it. Everything seems right. Except i still get the error message with VB6 My connection string: Dim conn As ADODB.Connection Dim constr As String Private Sub OpenServer() Set conn = New ADODB.Connection constr = "Driver={MySQL ODBC 3.51 Driver};" & _ "PORT=" & db_port & ";" & _ "SERVER=" & db_server & ";" & _ "DATABASE=" & db_name & ";" & _ "UID=" & db_user & ";" & _ "PWD=" & db_pass & ";" & _ "OPTION=3;" & _ "STMT=;" conn.Open constr End Sub So how can i resolve this damned connection issue? and What are the odds that causes this? mysql vb6 remote-access share|improve this question asked Sep 10 '12 at 10:37 Berker Yüceer 2,074123978 It quite clearly says that it can't connect. Either the details are wrong or the server is not accessible from the internet. There is nothign your client code can do about it. –Deanna Sep 10 '12 at 11:44 @Deanna lol i didnt ask as whats wrong with my code. I just showed it for people who asks "Whats your connection string? You sure it works?" Anyway thanks for mentioning that my code cant do a thing and seems like i should have a fight with my provider to double check my server's remote access. Thanks. –Berker Yüceer Sep 10 '12 at 12:44 add a comment| 5 Answers 5 active oldest votes up vote 4 down vote accepted Hosts where you access their database server very rarely allow remote access to