centos7中mariadb的密码找回

centos7 + mariadb5.5.68

流程：

[root@VM-8-17-centos ~]# systemctl stop mariadb
[root@VM-8-17-centos ~]# mysqld_safe --skip-grant-tables --skip-networking &
[root@VM-8-17-centos ~]# mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 1
Server version: 5.5.68-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)]> -- 1. 加载授权按表
MariaDB [(none)]> flush privileges;

MariaDB [(none)]> -- 2. 更新root账号的密码
MariaDB [mysql]> update mysql.user set password=password("123") where user="root";
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

MariaDB [mysql]> -- 3. update之后一定要flush privileges; 否则生效
MariaDB [mysql]> flush privileges; 
Query OK, 0 rows affected (0.00 sec)

MariaDB [mysql]> -- 4. 到这一步基本上就搞定了。
MariaDB [mysql]> exit;
Bye
[root@VM-8-17-centos ~]# 5. 杀掉MySQL服务器
[root@VM-8-17-centos ~]# pkill mysql
[root@VM-8-17-centos ~]# 6. 重启MySQL服务器
[root@VM-8-17-centos ~]# systemctl start mariadb
[root@VM-8-17-centos ~]# 7. 现在就可以正常的登录了
[root@VM-8-17-centos ~]# mysql -uroot -p123
[root@VM-8-17-centos ~]# mysql -uroot -p123
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 5.5.68-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)]>