哈宅哈宅

As title.

[color]

blue: shell bash instruction

green: instruction's parameters

gray: required value

purple: custom value

my steps:

1. download phpmyadmin-3.3.8.1-all-languages.tar.gz

> wget http://downloads.sourceforge.net/project/phpmyadmin/phpMyAdmin/3.3.8.1/phpMyAdmin-3.3.8.1-all-languages.tar.gz?r=http%3A%2F%2Fwww.phpmyadmin.net%2Fhome_page%2Fdownloads.php&ts=1291266404&use_mirror=nchc

2. uncompress phpmyadmin-3.3.8.1-all-languages.tar.gz

> tar zxf phpmyadmin-3.3.8.1-all-languages.tar.gz

3. (not requirment) copy phpMyAdmin-3.3.8.1-all-languages to another place

> cp -r phpMyAdmin-3.3.8.1-all-languages/* /var/www/phpmyadmin

4. (not requirment) edit httpd configure or .htaccess

> vim /etc/httpd/conf/httpd.conf

at the bottom, add the following:

> alias /phpmyadmin '/var/www/phpmyadmin'

5. copy config.sample.inc.php to config.inc.php

> cd /var/www/phpmyadmin

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

6. edit config.inc.php

reference: http://goo.gl/SDSgf

> vim config.inc.php

find $cfg['blowfish_secret'] = ''; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */, and modify it

> $cfg['blowfish_secret'] = 'mycustomvalue';

find /* Advanced phpMyAdmin features */, and uncomment the following:

> $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
> $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
> $cfg['Servers'][$i]['relation'] = 'pma_relation';
> $cfg['Servers'][$i]['table_info'] = 'pma_table_info';
> $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
> $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
> $cfg['Servers'][$i]['column_info'] = 'pma_column_info';
> $cfg['Servers'][$i]['history'] = 'pma_history';
> $cfg['Servers'][$i]['tracking'] = 'pma_tracking';
> $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';

7. import phpmyadmin database

reference: http://myandroid.tw/topic-274-0.htm

> mysql -u root -p your-root-password < /var/www/phpmyadmin/scripts/create_tables.sql 

8. finish~~php requirment: php-mcrypt

Requirement PHP Modules: php-mysql, php-mcrypt, php-mbstring