MySQL數(shù)據(jù)庫root登錄密碼忘記時(shí)如何修改
1.切換到MYSQL數(shù)據(jù)庫安裝的盤區(qū)并cd進(jìn)入bin目錄下,如圖:
2. 鍵入mysqld --skip-grant-tables就跳過了mysql身份驗(yàn)證(此時(shí)的DOS窗口不用,另打開一個(gè)dos窗口),然后鍵入mysql ,如圖所示:(注意:鍵入mysql命令之前確定關(guān)閉mysql服務(wù)和結(jié)束mysql.exe進(jìn)程)
3.鍵入show
databases;
4.鍵入use
mysql
5.鍵入show tables;
6.鍵入select user,host,password from user;
7.鍵入update user set password=password('617dcd418478') where user='root' and host='localhost';
如下圖所示,說明修改成功----------------------------------(617dcd418478為密碼)
8.mysql> flush privileges;
9.登錄測(cè)試:重啟MySQL數(shù)據(jù)庫,打開cmd.exe,鍵入mysql -uroot
-p617dcd418478回車,說明修改成功