Mysql

Installation:

sudo apt-get install mysql-server

Login as root

mysqladmin -u root -p

Create a Database:

mysqladmin -u root -p create testdb

Check Databases:

mysql -u root -p
show databases;

Select a Database:

use testdb;

Creating a user:

This section is under construction.

Connecting to a database directly:

mysql testdb -u user -pmypassword

Granting access to the Databse:

This section is under construction.

Export DB

mysqldump testdb > testdb.sql -p

Import DB

mysql testdb < /var/www/html/test.com/testdb.sql -p