1. Login on mysql command mysql -u root -h localhost -p 2. Check Status mysql> status 3. show databases mysql> show databases; 4. Show variables mysql> show variables; 5. Show processlist mysql> show processlist; 6. Using and selecting system already available mysql database mysql> use mysql; mysql> select database(); 7. select user table in mysql database mysql> select Host, User from user or mysql> select Host, User from mysql.user 8. Create database and display it mysql> create database tempDB; mysql> show databases; mysql> use tempDB; mysql> select database(); 9. Drop database mysql> drop database tempDB; mysql> show databases; 10. exit mysql mysql> exit