1 頁 (共 1 頁)

[問題] 關於phpMyAdmin登出系統問題

發表於 : 2005-01-07 16:50
sunmi629
要登出phpMyAdmin系統,結果一直出現要輸入使用者帳號及密碼視窗,輸入幾次(約三次),就出現以下訊息:

 歡迎使用 phpMyAdmin 2.5.4

 錯誤的使用者名稱或密碼,拒絕存取

請問這是什麼問題勒!!
:oops: 謝謝!!

Re: [問題] 關於phpMyAdmin登出系統問題

發表於 : 2005-04-15 23:32
Jone
sunmi629 寫:要登出phpMyAdmin系統,結果一直出現要輸入使用者帳號及密碼視窗,輸入幾次(約三次),就出現以下訊息:

 歡迎使用 phpMyAdmin 2.5.4

 錯誤的使用者名稱或密碼,拒絕存取

請問這是什麼問題勒!!
:oops: 謝謝!!
我也是有這種情形說 我是用 2.4.1

我現在進入phpmyadmin沒有問題

但是想要登出卻都不行 帳號密碼不對 :?:

步是同一組嗎 :cry:

我改的東西有 phpMyAdmin 登入
http://phpbb-tw.net/phpbb/viewtopic.php?t=16221

還有
SQL 語法:
# 刪除 ''@'%' ...
DELETE FROM `user` WHERE `User` = '' AND `Host` = '%';

DELETE FROM `db` WHERE `User` = '' AND `Host` = '%';

DELETE FROM `tables_priv` WHERE `User` = '' AND `Host` = '%';

DELETE FROM `columns_priv` WHERE `User` = '' AND `Host` = '%';

# 刪除 ''@'localhost' ...
DELETE FROM `user` WHERE `User` = '' AND `Host` = 'localhost';

DELETE FROM `db` WHERE `User` = '' AND `Host` = 'localhost';

DELETE FROM `tables_priv` WHERE `User` = '' AND `Host` = 'localhost';

DELETE FROM `columns_priv` WHERE `User` = '' AND `Host` = 'localhost';

# 刪除 'root'@'%' ...
DELETE FROM `user` WHERE `User` = 'root' AND `Host` = '%';

DELETE FROM `db` WHERE `User` = 'root' AND `Host` = '%';

DELETE FROM `tables_priv` WHERE `User` = 'root' AND `Host` = '%';

DELETE FROM `columns_priv` WHERE `User` = 'root' AND `Host` = '%';

# 刪除 'root'@'localhost' ...
DELETE FROM `user` WHERE `User` = 'root' AND `Host` = 'localhost';

DELETE FROM `db` WHERE `User` = 'root' AND `Host` = 'localhost';

DELETE FROM `tables_priv` WHERE `User` = 'root' AND `Host` = 'localhost';

DELETE FROM `columns_priv` WHERE `User` = 'root' AND `Host` = 'localhost';

# 重新讀取權限 ...
FLUSH PRIVILEGES ;
雖然不用登出 直接關掉也可以 不過我希望可以找出真正錯誤的原因 :oops:

請指教 !!