linux mariadb忘记密码,Mariadb忘记root密码解决办法

主机环境:

[root@test ~]# lsb_release -a

LSB Version: :core-4.1-amd64:core-4.1-noarch

Distributor ID: CentOS

Description: CentOS Linux release 7.4.1708 (Core)

Release: 7.4.1708

Codename: Core

[root@test ~]# uname -a

Linux test 3.10.0-693.2.2.el7.x86_64 #1 SMP Tue Sep 12 22:26:13 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux

mariadb yum安装参考:https://www.tracymc.cn/archives/614

具体解决过程:

1.首先停止mysql服务进程:

[root@test ~]# systemctl stop mariadb

然后编辑mysql的配置文件my.cnf,找到[mysqld]这个模块,在最后面添加一段代码skip-grant-tables(忽略mysql权限问题,直接登录),最后保存退出.

[root@test ~]# cat /etc/my.cnf

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

skip-grant-tables    //mysqld下面新增这行

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

# Settings user and group are ignored when systemd is used.

# If you need to run mysqld under a different user or group,

# customize your systemd unit file for mariadb according to the

# instructions in http://fedoraproject.org/wiki/Systemd

[mysqld_safe]

log-error=/var/log/mariadb/mariadb.log

pid-file=/var/run/mariadb/mariadb.pid

#

# include all files from the config directory

#

!includedir /etc/my.cnf.d

启动mysql服务:

[root@test ~]# systemctl start mariadb

直接进入mysql数据库,使用mysql库的user表,然后修改mysql的root密码(这里将新密码改为123456):

将MySQL的登录设置修改回来,将刚才在[mysqld]的段中加上的skip-grant-tables删除或者注释:

[root@test ~]# cat /etc/my.cnf

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

#skip-grant-tables    //把这行注释

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

# Settings user and group are ignored when systemd is used.

# If you need to run mysqld under a different user or group,

# customize your systemd unit file for mariadb according to the

# instructions in http://fedoraproject.org/wiki/Systemd

[mysqld_safe]

log-error=/var/log/mariadb/mariadb.log

pid-file=/var/run/mariadb/mariadb.pid

#

# include all files from the config directory

#

!includedir /etc/my.cnf.d

重启mysql服务,并用新密码(123456)登录:

至此,密码找回完成.