remote server connect with mysql

Question

Hi,

I have mysql 5.1 set up and running.

I need to connect to:

location: comm.eng.bxg.com

name: amntxy

user: username

pswd: password

I have tried using

mysql -h amntxy -u username -p

Also tried: use amntxy and use comm.eng.bxg.com/amntxy

But I am unable to connect.

I get the following error:

ERROR 2005 (HY000): Unknown MySQL server host

I also tried mysql_connect but keep getting the error : mysql_connect is not recognized as internal or external command

But I do not understand hwo I can connect here.

Please help.

Thank you

Answer 1

mysql -h comm.eng.bxg.com -u username -p

After this it will ask for a password.

Optionally you can also directly specify the database name that you want:

mysql -h comm.eng.bxg.com -u username -p db_name

But again, this is 100% optional. You will be able to select or change it after with the command USE db_name.