Why can't I connect to a remote host using MySQL Command Line Client?

Question

I can connect to my localhost and local databases using MySQL Command Line Client. I can't connect to a remote host using MySQL Command Line Client. I've tried a thousand different options like:

-h hostname -P port -u username -p password
mysql -h hostname -P port -u username -p password
\r -h hostname -P port -u username -p password


Any idea as to what am I doing wrong?

Answer 1

should be

mysql -h hostname -P port -u username -ppassword



the password is concated

Answer 2

If you are trying to remotely connect to a mysql server you must have the privelages setup to accept the ip address that is going to connect.



On most mysql server installations the only connection accepted is localhost



Once you setup the privelage you should be able to do a remote connection.



Also, for the sake of getting better error messages, I would suggest you download the MySQL Administrator for windows...



http://www.snapfiles.com/get/mysqlcc.html

Answer 3

This requires another computing language such as informix .