当前位置 博文首页 > 小小之食人魔：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)]> 成功
