Connecting remotely with a connect string?
| User, date | Message |
|---|---|
|
Written by vivoices
3 years ago Category: Creating a connection 3 posts since Mon, 26 Apr 10 |
Hi, I need to connect remotely with a connect string like: mysql -h 123.456.789.123 -u USERNAME -p DATABASE How can I set up a connection that uses such a connect string? David |
|
Written by kalvaro
3 years ago 457 posts since Thu, 29 Nov 07 |
Hostname/IP: 123.456.789.123 User: USERNAME Leave default values for other fields. |
|
Written by vivoices
3 years ago 3 posts since Mon, 26 Apr 10 |
Thanks for your reply, I did try connecting as you suggested, with and without compressed protocol. SQL Error (2003): Can't connect to MySQL server on 'xxx.xxx.xxx.xxx' (10060) In my ISP's control panel I added a wildcard % to the list of the MySQL Remote Database Access Hosts. Any Ideas? |
|
Written by kalvaro
3 years ago 457 posts since Thu, 29 Nov 07 |
Are external connections enabled on the server? What do you get when you type this is a Windows command prompt: telnet 123.456.789.123 3306 |
|
Written by vivoices
3 years ago 3 posts since Mon, 26 Apr 10 |
When I ping the IP, I get a proper reply, but tenet ip 3306 replies with: Connecting To xxx.xxx.xxx.xxx...Could not open connection to the host, on port 3306: Connect failed I will contact the IS tech support |
|
Please login to leave a reply, or register at first. |