Here I am trying to give a full instant guide to Mysql commands that will help people for their easy usage.
To login (from unix shell) use -h only if needed.
# [mysql dir]/bin/mysql -h hostname -u username -ppassword
To login (from windows)
mysql dir/bin/mysql.exe -h hostname -u username -ppassword
Create a database.
mysql> create database [databasename];
List all databases on the server.