MySQL如何忘记root密码

92次阅读

共计 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

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 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

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 如何忘记 root 密码”这篇文章的所有内容，感谢各位的阅读！相信大家都有了一定的了解，希望分享的内容对大家有所帮助，如果还想学习更多知识，欢迎关注丸趣 TV 行业资讯频道！

正文完