Connecting remotely with a connect string?

[expired user #4887]'s profile image [expired user #4887] posted 14 years ago in Creating a connection Permalink
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
kalvaro's profile image kalvaro posted 14 years ago Permalink
Hostname/IP: 123.456.789.123
User: USERNAME

Leave default values for other fields.
[expired user #4887]'s profile image [expired user #4887] posted 14 years ago Permalink
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?
kalvaro's profile image kalvaro posted 14 years ago Permalink
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
[expired user #4887]'s profile image [expired user #4887] posted 14 years ago Permalink
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.