竹貓星球

那個,我有爬文,然後依照每個人的意見做修改,結果越弄越糟的趨勢...

起因是最近管理的位置一直在斷電,造成資料庫有些毀損,

所以在今天發現xoops不能登入,就想去phpmyadmin修理,結果平常的帳號密碼不能登入

然後我就上網查了,知道要去C:\AppServ\www\-phpMyAdmin\config.inc.php修改東西,

但是改一改

最後結果是這樣
$cfg['Servers'][$i]['compress'] = FALSE; // Use compressed protocol for the MySQL connection
// (requires PHP >= 4.3.0)
$cfg['Servers'][$i]['hide_db'] = 'information_schema';

$cfg['Servers'][$i]['controluser'] = 'root'; // MySQL control user settings
// (this user must have read-only
$cfg['Servers'][$i]['controlpass'] = '1234'; // access to the "mysql/user"
// and "mysql/db" tables).
// The controluser is also
// used for all relational
// features (pmadb)
$cfg['Servers'][$i]['auth_type'] = 'http'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = ''; // MySQL user




一開始我將表格改成這樣,

$cfg['Servers'][$i]['controluser'] = '';

$cfg['Servers'][$i]['controlpass'] = '';

$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = '';

結果出現#1045 - Access denied for user 'root'@'localhost' (using password: NO)

後來改成
$cfg['Servers'][$i]['controluser'] = 'root';

$cfg['Servers'][$i]['controlpass'] = '1234';

$cfg['Servers'][$i]['auth_type'] = 'http';
$cfg['Servers'][$i]['user'] = 'root';

$cfg['Servers'][$i]['password'] = '1234';

出現輸入帳號密碼的視窗,但是不管輸入什麼都沒用...

然後就變成最後結果了.

對了,做到一半時我有把備份的config.inc.php放進去,結果什麼情況都沒變,

現在有點不知道該怎麼辦了...

建議您:
尋求該資料庫之管理者支援.