Win10系统MySQL5.7密码忘记怎么重置?

在Win10系统下安装了mySQL使用，有时遇到密码忘记的问题也是挺遭心的，那么如何重置mysql密码呢？下面小编就分享下具体教程。




Win10下mysql密码重置步骤如下：


1、首先点击开始菜单，搜索cmd.exe，左击以管理员身份运行

操作之前先备份好数据库（切忌）

C:\Users\Administrator>cd C:\Program Files\MySQL\MySQL Server 5.7\binC:\Program Files\MySQL\MySQL Server 5.7\bin>mysqld --skip-grants-tables//发现不成功，原因是没有data目录，于是在此C:\Program Files\MySQL\MySQL Server 5.7目录下创建了data目录，成功执行且可以跳过认证//但是进入数据库发现原来的库都不见了，原来是默认情况下，MySQL的数据库文件是保存在C:/ProgramData/mysql/MySQL Server 5.7/Data/ 而且，Win7，Win10缺省是把C:/ProgramData目录隐藏的。//因此我们需要指定配置文件来启动C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqld --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" --user=mysql --skip-grants-tables 

//进入数据库

C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqlWelcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 9Server version: 5.7.21-log MySQL Community Server (GPL)Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql>show databases;+--------------------+| Database |+--------------------+| information_schema || ds_bi || ixcrm || karryofficial || mysql || performance_schema || sanya || sys || zyyguahao |+--------------------+9 rows in set (0.00 sec)mysql> use mysql;Database changedmysql> show tables;+---------------------------+| Tables_in_mysql |+---------------------------+| columns_priv || db || engine_cost || event || func || general_log || gtid_executed || help_category || help_keyword || help_relation || help_topic || innodb_index_stats || innodb_table_stats || ndb_binlog_index || plugin || proc || procs_priv || proxies_priv || server_cost || servers || slave_master_info || slave_relay_log_info || slave_worker_info || slow_log || tables_priv || time_zone || time_zone_leap_second || time_zone_name || time_zone_transition || time_zone_transition_type || user |+---------------------------+31 rows in set (0.00 sec)mysql> desc user;+------------------------+-----------------------------------+------+-----+-----------------------+-------+| Field | Type | Null | Key | Default | Extra |+------------------------+-----------------------------------+------+-----+-----------------------+-------+| Host | char(60) | NO | PRI | | || User | char(32) | NO | PRI | | || Select_priv | enum('N','Y') | NO | | N | || Insert_priv | enum('N','Y') | NO | | N | || Update_priv | enum('N','Y') | NO | | N | || Delete_priv | enum('N','Y') | NO | | N | || Create_priv | enum('N','Y') | NO | | N | || Drop_priv | enum('N','Y') | NO | | N | || Reload_priv | enum('N','Y') | NO | | N | || Shutdown_priv | enum('N','Y') | NO | | N | || Process_priv | enum('N','Y') | NO | | N | || File_priv | enum('N','Y') | NO | | N | || Grant_priv | enum('N','Y') | NO | | N | || References_priv | enum('N','Y') | NO | | N | || Index_priv | enum('N','Y') | NO | | N | || Alter_priv | enum('N','Y') | NO | | N | || Show_db_priv | enum('N','Y') | NO | | N | || Super_priv | enum('N','Y') | NO | | N | || Create_tmp_table_priv | enum('N','Y') | NO | | N | || Lock_tables_priv | enum('N','Y') | NO | | N | || Execute_priv | enum('N','Y') | NO | | N | || Repl_slave_priv | enum('N','Y') | NO | | N | || Repl_client_priv | enum('N','Y') | NO | | N | || Create_view_priv | enum('N','Y') | NO | | N | || Show_view_priv | enum('N','Y') | NO | | N | || Create_routine_priv | enum('N','Y') | NO | | N | || Alter_routine_priv | enum('N','Y') | NO | | N | || Create_user_priv | enum('N','Y') | NO | | N | || Event_priv | enum('N','Y') | NO | | N | || Trigger_priv | enum('N','Y') | NO | | N | || Create_tablespace_priv | enum('N','Y') | NO | | N | || ssl_type | enum('','ANY','X509','SPECIFIED') | NO | | | || ssl_cipher | blob | NO | | NULL | || x509_issuer | blob | NO | | NULL | || x509_subject | blob | NO | | NULL | || max_questions | int(11) unsigned | NO | | 0 | || max_updates | int(11) unsigned | NO | | 0 | || max_connections | int(11) unsigned | NO | | 0 | || max_user_connections | int(11) unsigned | NO | | 0 | || plugin | char(64) | NO | | mysql_native_password | || authentication_string | text | YES | | NULL | || password_expired | enum('N','Y') | NO | | N | || password_last_changed | timestamp | YES | | NULL | || password_lifetime | smallint(5) unsigned | YES | | NULL | || account_locked | enum('N','Y') | NO | | N | |+------------------------+-----------------------------------+------+-----+-----------------------+-------+45 rows in set (0.00 sec)mysql> select user,host,authentication_string from user;+---------------+-----------+-------------------------------------------+| user | host | authentication_string |+---------------+-----------+-------------------------------------------+| root | localhost | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B || mysql.session | localhost | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE || mysql.sys | localhost | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE || biyu | % | *EDC20FCB679DE26150946AA0D8FF74CE730128ED |+---------------+-----------+-------------------------------------------+4 rows in set (0.00 sec)mysql> update user set authentication_string=password('123456') where user='root' and host='localhost';mysql> flush privileges; #更新权限//退出再使用新密码登陆,上面的红色密码 root 等改成自己的用户名和密码 

方法二：

mysql > set password for root@localhost = password('mysqlroot');

方法三：

mysqladmin -u UserName -h Host password 'new_password' -p以上就是小编分享的在Win10系统下mySQL密码忘记之后的重置方法了，希望大家能喜欢。