MySQL Commands

Description Command
To login (from unix shell) use -h only if needed. [mysql dir]/bin/mysql -h hostname -u root -p
Create a database on the sql server create database [databasename];
List all databases on the sql server show databases;
Switch to a database use [db name];
To see all the tables in the db show tables;