mysql查找密码忘记了

Question

我忘记了 MySql root 密码。我怎样才能找到它？

如何备份数据库和导入新数据库？

我试图在这个文件中更改用户密码中的 root 密码和权限；

"c:/Program Data/MySql/MySql Server 5.6/data/mysql/user.frm"

enter image description here

Answer 1

Mysql修改忘记密码

0) shut down service mysql56

1) go to C:\ProgramData\MySQL\MySQL Server 5.6
 (note that ProgramData is a hidden folder)

2) look for file my.ini, open it and add one line skip-grant-tables below [mysqld],
      save  [mysqld]

skip-grant-tables
3) start service mysql56

4) by right, you can access the database, and use the query below to update the password

update mysql.user set password=PASSWORD('NEW PASSWORD') where user='root';
5) shun down the service again, remove the line skip-grant-tables save it, and start the service again. try to use the password you set to login.