mysql中root密碼忘記了怎么辦

146次閱讀

共計(jì) 1707 個字符，預(yù)計(jì)需要花費(fèi) 5 分鐘才能閱讀完成。

丸趣 TV 小編給大家分享一下 mysql 中 root 密碼忘記了怎么辦，相信大部分人都還不怎么了解，因此分享這篇文章給大家參考一下，希望大家閱讀完這篇文章后大有收獲，下面讓我們一起去了解一下吧！

讓 mysql 不載入權(quán)限表，命令：mysqld –skip-grant-tables

命令：mysqld –skip-grant-tables（windows）
mysqld_safe –skip-grant-tables user=mysql 或者 /etc/init.d/mysql start –mysqld –skip-grant-tables（linux）

Windows 平臺例子:
C:\Users\duansf mysqld –skip-grant-tables

打開另外一個命令窗口，進(jìn)入 mysql 的交互界面
C:\Users\duansf mysql -uroot -p
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 15
Server version: 5.5.13 MySQL Community Server (GPL)

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

mysql use mysql
Database changed

mysql update user set Password=password(123456) where user= root
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql commit;
Query OK, 0 rows affected (0.00 sec)

mysql flush privileges;
Query OK, 0 rows affected (0.24 sec)

重新登陸驗(yàn)證密碼修改是否成功
C:\Users\duansf mysql -u root -p123456
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 16
Server version: 5.5.13 MySQL Community Server (GPL)

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

以上是“mysql 中 root 密碼忘記了怎么辦”這篇文章的所有內(nèi)容，感謝各位的閱讀！相信大家都有了一定的了解，希望分享的內(nèi)容對大家有所幫助，如果還想學(xué)習(xí)更多知識，歡迎關(guān)注丸趣 TV 行業(yè)資訊頻道！

正文完