ubuntu mysql commands

installation: open terminal and type
sudo apt-get install mysql

login to mysql server with a username and password:
mysql -u <user-name> -p
When prompt asks to enter password, enter password


mysql essential commands:

show databases;
//shows existing databases

use <database-name>;
//selecting a database

show tables;
//shows tables in the current database

select * from table1;
//selects all records from table1