Login to MySQL:

~$ mysql -u username -p

Create a database:

create database db_name;

Delete a database:

drop database db_name;

List all databases:

show databases;

Select a database:

use db_name;

List tables of current database:

show tables;

List fields of a table:

describe table_name;

Table query structure:

select * from table_name where id = "5" 

Export a MySQL Database:

~$ mysqldump -u username -p db_name > FILE.sql 

Import a MySQL Database:

~$ mysql -u username -p db_name < FILE.sql