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 日 03 : 46 PM © 允许规范转载 赞赏 如果觉得我的文章对你有用，请随意赞赏 ×Close 赞赏作者 扫一扫支付 支付宝支付 微信支付
