====== Installation ======
  * download phpMyAdmin-2.11.2.2 from its [[http://www.phpmyadmin.net/home_page/index.php | homepage]]
  * enter daemon account
  * extract it to /home/yxue/www/php and rename it to myadmin
  * under directory "myadmin"
<code>
cp config.sample.inc.php config.inc.php
</code>

  * edit config.inc.php
<code>
$cfg['blowfish_secret'] = 'snowrecall is me'  /* use whatever phrase you like */
</code>

  * default config.inc.php will provide a user/password box while logging-in, and give you a chance to save it as cookie. If you prefer to save user and password in this configure, simply change the content of config.inc.php, as indicated in Documentation.txt under "myadmin" directory.
<code>
$i=0;
$i++;
$cfg['Servers'][$i]['user'] = 'root'
$cfg['Servers'][$i]['password'] = '<your password>'
?>
</code>
  * cp "chemicals" & "databackup" database to /home/usr/www/mydb and create a soft link pointing in /var/lib/mysql
  * use this link "http://rabi.chem.purdue.edu/php/myadmin" to visit phpMyAdmin (using root password of mysql)
====== Create database using phpMyAdmin (take "databackup database as an example) ======
  * create database: login to phpMyAdmin and find "Create new database" section on the right list; Input database name as "databackup", and collation as "utf8-bin"
  * create table: Find "Create new table" section; Input table name as "datbak" and number of fields as "3"; click "go" button.
  * Add three column:
<code>
`label` VARCHAR( 16 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL PRIMARY KEY,
`date` DATE NOT NULL ,
`descrip` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
</code>
  * Add record: Click datbak table on the left, and choose "Insert" tab.

====== Troubleshooting ======
===== Cannot enter the interface when click login =====
 * Solution: change permission of /var/lib/php to nobody:nogroup (which is user:group for my current lighttpd)