ERROR 1044 (42000):Access denied for user 'axt'@'%' to database 'dbadapter'解決
環境:MySQL Sever 5.1 + MySQL命令行工具
問題:MySQL用戶遠程登錄後操作數據庫遇到此問題:ERROR 1045 (28000): Access denied for user 'axt'@'localhost' (usingpassword: YES)。
www.2cto.com
解決:權限問題。重新授權,flush後重啟MySQL服務。
也可以使用Navicat for MySQL的用戶管理解決(數據庫------>右鍵------>管理用戶------->授予用戶權限)。
如圖:
參考資料:
Access denied for user ''@'localhost'
http://bytes.com/topic/mysql/answers/714421-access-denied-user-localhost;
ERROR 1044 (42000): Access denied for user''@'localhost' to database 'mysql'
http://www.BkJia.com/database/201209/154903.html;
ERROR 1044 (42000): Access denied for user''@'localhost' to database 'db'
http://stackoverflow.com/questions/8838777/error-1044-42000-access-denied-for-user-localhost-to-database-db;
求助數據庫連接:ERROR 1045 (28000): Access denied for user (using password: YES)
http://bbs.chinaunix.net/thread-658853-1-1.html