• download phpMyAdmin-2.11.2.2 from its homepage
• enter daemon account
• extract it to /home/yxue/www/php and rename it to myadmin
• under directory “myadmin”

cp config.sample.inc.php config.inc.php

• edit config.inc.php

$cfg['blowfish_secret'] = 'snowrecall is me'  /* use whatever phrase you like */

• 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.

$i=0;
$i++;
$cfg['Servers'][$i]['user'] = 'root'
$cfg['Servers'][$i]['password'] = '<your password>'
?>

• 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: 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:

`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 ,

• Add record: Click datbak table on the left, and choose “Insert” tab.

* Solution: change permission of /var/lib/php to nobody:nogroup (which is user:group for my current lighttpd)