[MYAQL / Mariadb] 数据库学习-破解数据库密码

忘记数据库密码恢复，先在配置文件/etc/my.cnf 中，定义登录无需密码skip_grant_tables 。并重启

[root@control ~]# cat /etc/my.cnf
#
# This group is read both both by the client and the server
# use it for options that affect everything
#
[client-server]

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

# [mysqld]
# secure_file_priv='/myload'

skip_grant_tables


[root@control ~]# systemctl restart mysqld.service

在MySQL中查看root登录密码信息（没配置所以是空的）

mysql> select user,host,authentication_string from mysql.user;
+------------------+-----------+------------------------------------------------------------------------+
| user             | host      | authentication_string                                                  |
+------------------+-----------+------------------------------------------------------------------------+
| mysql.infoschema | localhost | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| mysql.session    | localhost | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| mysql.sys        | localhost | $A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED |
| root             | localhost |                                                                        |
+------------------+-----------+------------------------------------------------------------------------+
4 rows in set (0.00 sec)

配置密码并刷新，再改配置文件、重启服务，重新登陆