Loading... # MariaDB 重置密码记录 *果你 Linux 上的 MariaDB 数据库密码忘记了,你可以这样来重置密码。* ```csharp [root@node1 ~]# mysql -uroot -p ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) ``` ## 目标: 重置 MariaDB 数据库密码 ## 过程: 修改配置文件: ```bash [root@node1 ~]# vi /etc/my.cnf [mysqld] skip-grant-tables(添加这句,跳过权限列表) ``` 重启 MariaDB: ```bash [root@node1 ~]# systemctl restart mariadb ``` 用 MySQL 命令就可以直接进入数据库: ```bash [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 用户密码: ```bash 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: ```bash [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)]> 成功 ``` 最后修改:2020 年 09 月 25 日 © 允许规范转载 打赏 赞赏作者 支付宝微信 赞 0 如果觉得我的文章对你有用,请随意赞赏