MySQL如何遗忘root密码
发布时间：2021-12-23 11:54:39 所属栏目：MySql教程 来源：互联网
导读：这篇文章主要为大家展示了MySQL如何忘记root密码，内容简而易懂，条理清晰，希望能够帮助大家解决疑惑，下面让小编带领大家一起研究并学习一下MySQL如何忘记root密码这篇文章吧。 1、启动MySQL [root@localhost ~]# mysqld_safe --skip-grant-tables 2、登
|
这篇文章主要为大家展示了“MySQL如何忘记root密码”，内容简而易懂，条理清晰，希望能够帮助大家解决疑惑，下面让小编带领大家一起研究并学习一下“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密码”这篇文章的所有内容，感谢各位的阅读！ （编辑：温州站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
