Access Mysql Server from Terminal

Mysql Server Commands

#Anything surrounded in parenthesis represent a databasename / tablename
# Any Command in mysql requires a semi colon{;} after each statement

#Start Mysql
mysql.server start # <------ In Terminal, say Ruby on rails Application -->

#Access Databases
mysql -uroot # <--- In Terminal -->

#Select Database
use (database name here, not paranthesis); # In Mysql Requires Semi colon -->

#Show Tables in Database
show tables from (database name);  # In Mysql Requires Semi colon -->

#Show Columns from table in database
show columns from table (tablename);  # In Mysql Requires Semi colon -->