distal-attribute
distal-attribute
distal-attribute
distal-attribute

Connecting remotely with a connect string?

User, date Message
Written by vivoices
4 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
4 years ago
593 posts since Thu, 29 Nov 07
Hostname/IP: 123.456.789.123
User: USERNAME

Leave default values for other fields.
Written by vivoices
4 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
4 years ago
593 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
4 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.