linux mariadb忘记密码,Linux上mariadb重置密码

如果你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)]> 成功