如果你Linux上的mariadb數(shù)據(jù)庫密碼忘記了，你可以這樣來重置密碼吼畏。
[root@node1 ~]# mysql -uroot -p
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
目標(biāo):
重置Mariadb數(shù)據(jù)庫密碼
過程：
修改配置文件：
[root@node1 ~]# vi /etc/my.cnf
[mysqld]
skip-grant-tables（添加這句，跳過權(quán)限列表）
重啟mariadb：
[root@node1 ~]# systemctl restart mariadb
用mysql命令就可以直接進入數(shù)據(jù)庫：
[root@node1 ~]# mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 10.1.17-MariaDB MariaDB Server
Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
修改root用戶密碼：
MariaDB [(none)]> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
MariaDB [mysql]> update user set Password=Password("111111") where user="root";
Query OK, 4 rows affected (0.00 sec)
Rows matched: 4 Changed: 4 Warnings: 0
驗證：
去掉skip-grant-tables昵骤，重啟maridb：
[root@node1 ~]# systemctl restart mariadb
[root@node1 ~]# mysql -uroot -p111111
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 218
Server version: 10.1.17-MariaDB MariaDB Server
Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> 成功
