phpmyadmin setup for mysql

apache httpd 2.2.3
php 5.2.6
phpmyadmin 2.9.0.2, 2.11.9.4
mysql-5.1.30-win32

(1)>將phpmyadmin的zip檔解壓
放到apache的DocumentRoot路徑 (htdoc folder in windows os, var/www/html folder in linux from default)

(2)＞配置config.inc.php文件
將phpmyadmin目錄中的config.sample.inc.php文件複製一份並改名為config.inc.php。

(3)增加帳號密碼資訊

若$cfg['Servers'][$i]['auth_type'] = 'config';為(直接將資料庫的帳號、密碼儲存於 config.inc.php 檔案)
$cfg['blowfish_secret'] = '';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '密碼'

若$cfg['Servers'][$i]['auth_type'] = 'cookie';為 (使用 blowfish 演算法，對密碼進行加密)
$cfg['blowfish_secret'] = '任意字串';
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = '' //user及password留空即可

若$cfg['Servers'][$i]['auth_type'] = 'http';為
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = '' //user及password留空即可

在這邊我遇到了一些問題:

(1)

MySQL said: 

#1045 - Access denied for user 'pmausr'@'localhost' (using password: YES)

遇到這個問題就把
$cfg['Servers'][$i]['controluser'] = 'pmausr';
$cfg['Servers'][$i]['controlpass'] = 'pmapass';

這二行砍掉或註解掉即可

(2)"Your PHP MySQL library version 5.0.45 differs from your MySQL server version 5.1.30. This may cause unpredictable behavior."

google之後也沒比較具體的解決方法，結論大概是mysql server版本比PHP的新，自行升降級囉。

不過我使用2.11.9.4會有這個警告訊息，但是使用2.9.0.2的版本卻沒有…

參考資源：

http://songxj.blog.51cto.com/620981/121319

http://www.discuz.net/thread-825309-1-3.html