Linux上mariadb重置密码 2019-05-24

如果你Linux上的mariadb数据库密码忘记了，你可以这样来重置密码。

[root@node1 ~]# mysql -uroot -p
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

目标:

重置Mariadb数据库密码

过程：

修改配置文件：

[root@node1 ~]# vi /etc/my.cnf
[mysqld]
skip-grant-tables（添加这句，跳过权限列表）

重启mariadb：

[root@node1 ~]# systemctl restart mariadb

用mysql命令就可以直接进入数据库：

[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)]> 成功