Connecting to MySQL via Command Line

[bigdainca]

For one of my clients, I am hosting a site through a hosting agency that supports PHP and MySQL. In addition to managing my tables and such through web pages, I would also like to manage them via the command line on my home computer (Windows XP).

If the domain name was www.domain.com, I am assuming I would connect using the following:

mysql -u username -h www.domain.com -D database_name -p password

This is not working correctly. Is this not possible to do? I have no problems whatsoever using this method to connect to my Apache localhost. Maybe I am missing something, but I can't find this information anywhere else.

Thanks!

Devin

[Erkilite]

Your host may not allow connections to the mysql server from anything other than the local computers.

Some hosts allow you to add an authorized IP or range of IPs so that you can access the server from another computer.