Start with:
mysql -u username -p
Then enter password.
Shows all databases allowed to see.
mysql> show databases;
Pick database to work on
mysql> use database_name;
See tables in database
mysql> show tables;
Get description of table
mysql> describe table_name;
Simple query to see all data in table_name
mysql> select * from table_name;