Mysql忘记 || 修改 数据库连接密码
解决方式:
1、cmd 进入 数据库安装目录:
D:\dev-env\mysql-5.7.26-winx64\bin
λ
在任务管理器中关闭 mysqld.exe 程序。
然后 输入如下命令:
mysqld --skip-grant-tables
输入命令 mysqld --skip-grant-tables 回车,此时就跳过了mysql的用户验证。注意输入此命令之后命令行就无法操作了,此时可以再打开一个新的命令行。注意:在输入此命令之前先在任务管理器中结束mysqld.exe进程,确保mysql服务器端已结束运行
然后直接输入 mysql ,不需要带任何登录参数直接回车就可以登陆上数据库
D:\dev-env\mysql-5.7.26-winx64\bin
λ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.26 MySQL Community Server (GPL)
Copyright (c) 2000, 2019, 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 |
| dev |
| mysql |
| performance_schema |
| sys |
+--------------------+
6 rows in set (0.00 sec)
mysql 数据库就是 保存用户信息的数据库。
输入
use mysql;
show tables; 可以查看所有表 :
mysql> use mysql
Database changed
mysql> show tables;
+---------------------------+
| Tables_in_mysql |
+---------------------------+
| ... |
| user |
+---------------------------+
31 rows in set (0.00 sec)
其他表忽略,user表就是保存用户信息的表,接下来就可以进行操作了。
注: 其中 authentication_string 字段就是 password
mysql> select user,host,authentication_string from user;
+---------------+-----------+-------------------------------------------+
| user | host | authentication_string |
+---------------+-----------+-------------------------------------------+
| root | localhost | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| mysql.session | localhost | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| mysql.sys | localhost | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| hap_dev | localhost | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
+---------------+-----------+-------------------------------------------+
4 rows in set (0.03 sec)
//修改密码
update mysql.user set authentication_string=password('123456') where user='dev' ;