Instructions for installing mySQL and adding a database on Ubuntu:

ITEMACTION
Install
  1. sudo apt-get install apache2 php libapache2-mod-php mysql-server phpmyadmin
Setup database
  1. Log into mySQL
    mysql -u root -p
  2. Within mySQL create database
    mysql> create database [dbname];
  3. mysql> quit;
  4. Load DB file
    mysql -u root -D [dbname] -p < DB.sql
View table
  1. Log into mySQL
    mysql -A -u root -p
  2. Select database to work with
    mysql> use [dbname];
  3. Show available tables
    mysql> show tables;
  4. Show table fields
    mysql> desc [table];
  5. Show table contents
    mysql> SELECT * FROM [table];
Refs