共计 1658 个字符，预计需要花费 5 分钟才能阅读完成。
这篇文章主要为大家展示了“MySQL 如何忘记 root 密码”，内容简而易懂，条理清晰，希望能够帮助大家解决疑惑，下面让丸趣 TV 小编带领大家一起研究并学习一下“MySQL 如何忘记 root 密码”这篇文章吧。
1、启动 MySQL
[root@localhost ~]# mysqld_safe –skip-grant-tables
2、登录 MySQL
[root@localhost ~]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.25a-log Source distribution
Copyright (c) 2000, 2011, 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 databases;
+——————–+
| Database |
+——————–+
| information_schema |
| allen |
| mysql |
| mytest |
| performance_schema |
| test |
+——————–+
6 rows in set (0.00 sec)
mysql use mysql
Database changed
mysql update user set password=PASSWORD(123456) where user= root – 修改 root 密码
Query OK, 4 rows affected (0.00 sec)
Rows matched: 4 Changed: 4 Warnings: 0
mysql flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql quit
Bye
3、重新使用密码登录
[root@localhost ~]# mysql -uroot -p123456
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.5.25a-log Source distribution
Copyright (c) 2000, 2011, 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 databases;
+——————–+
| Database |
+——————–+
| information_schema |
| allen |
| mysql |
| mytest |
| performance_schema |
| test |
+——————–+
6 rows in set (0.00 sec)
以上是“MySQL 如何忘记 root 密码”这篇文章的所有内容，感谢各位的阅读！相信大家都有了一定的了解，希望分享的内容对大家有所帮助，如果还想学习更多知识，欢迎关注丸趣 TV 行业资讯频道！
