windows環(huán)境下: mysql ERROR 1045 (28000): Access denied for user
首先編輯my.ini文件,添加跳過密碼驗證的功能:
skip-grant-tables
重啟mysql服務:
net stop mysql
net start mysql
此時在cmd下登錄數(shù)據(jù)就不需要密碼了:
mysql -u root -p ,
出現(xiàn)password時秘遏,直接回車進入
1.進入mysql數(shù)據(jù)庫:
mysql> use mysql;
Database changed
重新設置用戶密碼:
update user set password(或者 authentication_string)=password("新密碼") where user ="root"
Query OK, 1 rows affected (0.01 sec)Rows matched: 1 Changed: 1 Warnings: 0
刷新數(shù)據(jù)庫:
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
4.退出mysql:
mysql> quit
Bye
退出之后儡司,修改原來的my.ini文件,刪除掉剛才添加的那句話:skip-grant-tables.保存胡重啟mysql服務渐尿,這時重新登錄:mysql -u root -p ,就能密碼登錄咯醉途!