MariaDB忘记root密码

在MariaDB配置文件/etc/my.cnf  [mysqld]中加入skip-grant-tables一行：

[Richard@localhost ~]$ sudo vi /etc/my.cnf
[mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockskip-grant-tables　　　　#加入这一行# Disabling symbolic-links is reco

重启服务：

[Richard@localhost ~]$ sudo systemctl restart mariadb.service

进入MariaDB修改root密码：

[Richard@localhost ~]$ mysqlWelcome to the MariaDB monitor.  Commands end with ; or \g.Your MariaDB connection id is 2Server version: 5.5.40-MariaDB-wsrep MariaDB Server, wsrep_25.11.r4026Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.MariaDB [(none)]> use mysqlReading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedMariaDB [mysql]> show tables    -> ;+---------------------------+| Tables_in_mysql           |+---------------------------+| columns_priv              || db                        || event                     || func                      || general_log               || help_category             || help_keyword              || help_relation             || help_topic                || host                      || ndb_binlog_index          || plugin                    || proc                      || procs_priv                || proxies_priv              || servers                   || slow_log                  || tables_priv               || time_zone                 || time_zone_leap_second     || time_zone_name            || time_zone_transition      || time_zone_transition_type || user                      |+---------------------------+24 rows in set (0.00 sec)MariaDB [mysql]> UPDATE user SET Password = password ( '123456 ) WHERE User = 'root' ; Query OK, 4 rows affected (0.03 sec)Rows matched: 4  Changed: 4  Warnings: 0MariaDB [mysql]> flush privileges;Query OK, 0 rows affected (0.01 sec)MariaDB [mysql]> exit

重启服务即可登陆：

[Richard@localhost ~]$ sudo systemctl restart mariadb.service[Richard@localhost ~]$ mysql -u root -pEnter password: Welcome to the MariaDB monitor.  Commands end with ; or \g.Your MariaDB connection id is 2Server version: 5.5.40-MariaDB-wsrep MariaDB Server, wsrep_25.11.r4026Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.MariaDB [(none)]> exit