这篇文章主要介绍了Mysql忘记root密码怎么办,具有一定借鉴价值,感兴趣的朋友可以参考下,希望大家阅读完这篇文章之后大有收获,下面让小编带着大家一起了解一下。1.关闭mysql 服务 点击(此处
这篇文章主要介绍了Mysql忘记root密码怎么办,具有一定借鉴价值,感兴趣的朋友可以参考下,希望大家阅读完这篇文章之后大有收获,下面让小编带着大家一起了解一下。
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)
感谢你能够认真阅读完这篇文章,希望小编分享的“mysql忘记root密码怎么办”这篇文章对大家有帮助,同时也希望大家多多支持编程网,关注编程网数据库频道,更多相关知识等着你来学习!
--结束END--
本文标题: mysql忘记root密码怎么办
本文链接: https://www.lsjlt.com/news/62324.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-04-29
2024-04-29
2024-04-29
2024-04-29
2024-04-29
2024-04-29
2024-04-29
2024-04-29
2024-04-29
2024-04-28
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0