共計 1640 個字符，預計需要花費 5 分鐘才能閱讀完成。
這篇文章主要介紹了 mysql 忘記 root 密碼怎么辦，具有一定借鑒價值，感興趣的朋友可以參考下，希望大家閱讀完這篇文章之后大有收獲，下面讓丸趣 TV 小編帶著大家一起了解一下。
1. 關閉 mysql 服務
點擊 (此處) 折疊或打開
net stop mysql57
2. 執行 mysqld
– 打開 cmd 窗口，切換至 mysql 安裝目錄
點擊 (此處) 折疊或打開
cd C:\Program Files\MySQL\MySQL Server 5.7\bin
C:\Program Files\MySQL\MySQL Server 5.7\bin mysqld –defaults-file= C:\ProgramData\MySQL\MySQL Server 5.7\my.ini –skip-grant-tables
3. 新開啟 cmd, 登錄 root
- 不用輸入 password，直接回車
C:\Program Files\MySQL\MySQL Server 5.7\bin mysql -uroot -p
Enter password:
4. 修改 root 密碼
點擊 (此處) 折疊或打開
mysql use mysql;
Database changed
mysql update mysql.user set authentication_string=password(root) where user= root
Query OK, 1 row affected, 1 warning (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 1
mysql flush privileges;
Query OK, 0 rows affected (0.02 sec)
5. 使用新密碼登錄 root
點擊 (此處) 折疊或打開
C:\Program Files\MySQL\MySQL Server 5.7\bin mysql -uroot -p
Enter password: ****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.7.19 MySQL Community Server (GPL)
Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type help; or \h for help. Type \c to clear the current input statement.
mysql show database;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near datab
ase at line 1
mysql show databases;
+——————–+
| Database |
+——————–+
| information_schema |
| fortress |
| mysql |
| performance_schema |
| python |
| stuman |
| stuman2 |
| sys |
| www |
+——————–+
9 rows in set (0.00 sec)
感謝你能夠認真閱讀完這篇文章，希望丸趣 TV 小編分享的“mysql 忘記 root 密碼怎么辦”這篇文章對大家有幫助，同時也希望大家多多支持丸趣 TV，關注丸趣 TV 行業資訊頻道，更多相關知識等著你來學習!
