Mysql Connect 10060 Error
Contents |
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 cannot connect to mysql server 10061 Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow
2003, Can't Connect To Mysql Server On (10060)
Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Cannot aws mysql 10060 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
Cannot Connect To Mysql Server On Localhost 10061 Windows 7
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 mysql workbench connection error 10061 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,084123978 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 the database from
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
Mysql Cpanel
more about Stack Overflow the company Business Learn more about hiring developers or posting
Error 2003 Can't Connect To Mysql Server On 'localhost' (10061)
ads with us Server Fault Questions Tags Users Badges Unanswered Ask Question _ Server Fault is a question and answer connection failed: can't connect to mysql server on (110) 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 answers are voted up and rise http://stackoverflow.com/questions/12349948/cannot-connect-to-remote-mysql-with-vb6-10060 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 host to enable remote access, I have also made http://serverfault.com/questions/137418/remote-mysql-connection-fails-10060 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 to telnet (from another pc) to your mysql server: telnet ip_mysql_server 3306 This should open a telnet session: Connect
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 http://stackoverflow.com/questions/12349948/cannot-connect-to-remote-mysql-with-vb6-10060 Learn more about Stack Overflow the company Business Learn more about hiring developers or http://stackoverflow.com/questions/21627421/mysql-unable-to-connect-with-remote-server 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, helping each other. Join them; it only takes a minute: Sign up Cannot connect to remote MySQL with VB6 (10060) up connect to 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 connect to mysql 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,084123978 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
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 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up MySQL unable to connect with remote server up vote 5 down vote favorite 1 We have a MySQL server in one of the remote Virtual Machine (Windows Server 2008). Till yesterday we were able to connect to the MySQL server, with the help of workbench installed in our local machine. Yesterday there was a restart to the machine which has the Virtual Machine installed. After that we are unable to connect to MYSQL. Though I can ping and remote connect this particular VM. I can even execute the queries inside the workbench installed in the VM. I am not too good at networking or security related stuffs. Please help me to solve this issue. Error : Your connection attempt failed for user 'root' from your host to server at ABC:3306: Can't connect to MySQL server on 'ABC' (10060) mysql networking port windows-server-2008-r2 firewall share|improve this question edited Jan 23 at 9:28 marc_s 454k938701033 asked Feb 7 '14 at 12:08 TBA 3511835 Is the MYSQL Service running? Are there any erros in the logs (Event Viewer)? –nightlyop Feb 18 '14 at 7:18 Hi nightlyop it got solved... There was a mistake in the port number. Thanks –TBA Feb 18 '14 at 8:56 add a comment| 5 Answers 5 active oldest votes up vote 14 down vote accepted +100 Really this could be a magnitude of possible reasons, hopefully this is a start: Check basic network From the MySQL virtual machine open up a command prompt and type IPCONFIG /ALL. This will show you all the IP addresses bound to different network adapters. Check that the IP address you're connected to is listed there, the virtual machine might have got a new IP from DHCP rather than having a static IP after its restart. Hostname vs IP You sh