在Win2K上安裝 phpMyAdmin-2.11.1-all-languages

在Win2K上安裝 phpMyAdmin-2.11.1-all-languages

(1) 解壓縮到C:\Apache2.2\htdocs\ 並改名為 phpMyAdmin
(2) 複製config.sample.inc.php to config.inc.php
(3) 修改 config.inc.php內容

----------config.inc.php內容----------
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'http'; /*將cookie改為http*/
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['user'] = '登入MySQL資料庫帳號';
$cfg['Servers'][$i]['password'] = '登入MySQL資料庫密碼';
----------config.inc.php內容----------

(4) 修改C:\WINNT\php.ini內容, 將extension=php_mysql.dll 前面的『;』comment取消
(5) Restart Apache
(6) 從C:\Apache2.2\php-5.2.4\ext\下複製php_mcrypt.dll,php_mysql.dll and libmysql.dll 到 C:\WINNT\下.
(7) 執行 http://localhost/phpmyadmin/index.php 就可以看到內容.

* 如果步驟(4)跟(6)沒有做到，就會出現『無法讀取 mysql 模組』訊息.

另外在舊資料庫轉移後會出現亂碼, 是因為舊資料庫是採latin1編碼, 而新版5.x版MySQL的default編碼是utf-8,
所以必須要在C:\Apache2.2\htdocs\phpMyAdmin\libraries\select_lang.lib.php修改內容:
找到底下，並將zhtw-utf-8的array內容改為chinese_traditional-big5:
'zhtw-big5' => array('zh[-_](tw|hk)|chinese traditional', 'chinese_traditional-big5', 'zh-TW', '中文'),
'zhtw-utf-8' => array('zh[-_](tw|hk)|chinese traditional', 'chinese_traditional-big5', 'zh-TW', '中文'),

---
再找到底下:
/**
* @global array MySQL charsets map
*/
$GLOBALS['mysql_charset_map'] = array(
...
'big5' => 'latin1', /*修改為 latin1*/
'utf-8' => 'latin1', /*修改為 latin1*/
...
);

存檔後refresh web page...