making a command line connection to a remote mysql server?

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

Re: making a command line connection to a remote mysql server?

mcyi2mr3@googlemail.com wrote:
> 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 -u -p

The entry for 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.