// use for configuration http://localhost/phpmyadmin/
# apt-get install apache2 phpmyadmin libapache2-mod-php5 php5-mysql

// enable InnoDB
# vi /etc/mysql/my.cnf
#skip-innodb
innodb_data_home_dir=/var/lib/mysql
innodb_data_file_path=ibdata1:10M:autoextend

# /etc/init.d/mysql restart

// database setup
$ mysql -u root -p
mysql> CREATE USER 'flyhigh'@'localhost' IDENTIFIED BY 'flyhigh';
mysql> GRANT ALL PRIVILEGES ON * . * TO 'flyhigh'@'localhost';
mysql> FLUSH PRIVILEGES;
mysql> CREATE DATABASE flyhigh_v2;
mysql> GRANT ALL PRIVILEGES ON flyhigh_v2.* TO 'flyhigh'@'localhost';
mysql> quit

/* OTHERS */
// backup the database
$ mysqldump flyhigh_v2 -h localhost -u root -p > flyhigh.sql

// restore the database
$ mysql -u root -p < flyhigh.sql
Enter password:

// remove the database
$ mysqladmin -u root -p drop flyhigh_v2
Enter password:

// query version of database
echo "SELECT Time FROM LastModified WHERE Name='DataBaseVersion'" | mysql -u flyhigh --password=flyhigh -D flyhigh_v2
