方法1 记得密码时，修改密码 首先登录 MySQL。 格式：mysql> set password for 用户名 @localhost = password(‘新密码’); 例子：mysql> set password for root@localhost = password(‘123’); 原地址:https://www.cnblogs.com/selier/p/9519911.html

方法2 忘记密码时，跳过权限进行修改

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=‘123456’ ; 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 © 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) 原地址：http://blog.itpub.net/15412087/viewspace-2151346/