making a command line connection to a remote mysql server?

[m***@googlemail.com]

hi all how do i make a command line connection to a remote mysql
server?

for local connections i know it is: mysql -u root dbname

how do i connect to a remote server with a password?

thanks

marc

[Carl Pearson]

Post by m***@googlemail.com
hi all how do i make a command line connection to a remote mysql
server?
for local connections i know it is: mysql -u root dbname
how do i connect to a remote server with a password?
thanks
marc

mysql -h <HOST> -u <USER> -p

The entry for <HOST> must be reachable by your machine.

Tip:
mysql --h > mysql.hlp.txt

will give you a file of all the command-line options which you may then
study at leisure.