Highly Cohesive

How To Login to MySql

• mysql -uuser -ppassoword
• Example mysql -uroot -pthisismypassword
• mysql –user=user –password=password
• Example mysql –user=root –password=thisismypassword

How to List databases in MySql

• at mysql command prompt> show databases;
• Ex:  mysql> show databases;

Select a database in MySql

• at mysql prompt> use databasename;
• Ex:  mysql> use my_db;

Select list of tables in MySql

• at mysql prompt> show tables;
• Ex:  mysql> show tables;

List columns in MySql table

• at mysql prompt> show columns from tablename;
• Ex: mysql> show columns from my_table;