To access a database from the command line, use:

mysql -u username -ppassword -h hostname databasename

(Note: there's no space between the -p and the password!)

To access a database remotely using a hostname, just create one below!
! Success!
Your database "mantis_elemental" has been created!

Your hostname "mysql.darkwynter.com" will be set up within about 5-10 minutes.
You MUST always use your hostname to connect to your database... "localhost" WILL NOT WORK.

Connect to your new database from the command line with:
mysql -u darkwynter -p -h mysql.darkwynter.com mantis_elemental
You can also go to http://mysql.darkwynter.com/ to manage your MySQL database from the web (once the hostname is set up of course).