MySQL遗忘Root密码

# systemctl stop mariadb                #关闭服务
# cat /etc/my.cnf                       #修改/etc/my.cnf文件,
...
[mysqld]
skip-grant-tables                       #在[mysqld]下添加 skip-grant-tables , 再启动mysql
...

# systemctl start mariadb               #启动服务
# mysql -u root                         #连接MySql(MariaDB) 并修改root密码为123654

    MariaDB [(none)]> update mysql.user set Password=password('123654') where User='root';
    Query OK, 1 row affected (0.01 sec)
    Rows matched: 4  Changed: 1  Warnings: 0
    MariaDB [(none)]> flush privileges;
    Query OK, 0 rows affected (0.00 sec)
    MariaDB [(none)]> quit;
    Bye

# cat /etc/my.cnf                       还原/etc/my.cnf文件,
...
[mysqld]
#skip-grant-tables                      #删除或注释添加的 skip-grant-tables
...

# systemctl restart mariadb             #重启服务