Mariadb重置密码

Mariadb忘记密码重置

一、进入配置文件

[root@wemmao ~]# vim /etc/my.cnf
添加[mysqld]下面
skip-grant-tables

image.png

二、重新启动Mariadb

[root@wenmao ~]# systemctl restart mariadb.service

三、进入Mysql

[root@wenmao ~]# mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 5.5.65-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> update mysql.user set password=password('123456') where user='root' and host='localhost'; 
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

MariaDB [(none)]> flush privileges;
Query OK, 0 rows affected (0.01 sec)

MariaDB [(none)]> exit

四、新更改密码为123456，在进入配置文件注释掉刚刚添加的命令。
然后重新启动Mariadb。

[root@wenmao ~]# vim /etc/my.cnf

image.png

[root@wenmao ~]# systemctl restart mariadb.service