Connecting remotely with a connect string?

vivoices posted 7 years ago in Creating a connection
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?

kalvaro posted 7 years ago
Hostname/IP: 123.456.789.123

Leave default values for other fields.
vivoices posted 7 years ago
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 posted 7 years ago
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
vivoices posted 7 years ago
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.