歡迎使用 phpMyAdmin 2.5.4
錯誤的使用者名稱或密碼,拒絕存取
請問這是什麼問題勒!!
版主: 版主管理群
我也是有這種情形說 我是用 2.4.1sunmi629 寫:要登出phpMyAdmin系統,結果一直出現要輸入使用者帳號及密碼視窗,輸入幾次(約三次),就出現以下訊息:
歡迎使用 phpMyAdmin 2.5.4
錯誤的使用者名稱或密碼,拒絕存取
請問這是什麼問題勒!!
謝謝!!
雖然不用登出 直接關掉也可以 不過我希望可以找出真正錯誤的原因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 ;