解决MariaDB或MySQL登录时忘记密码或出现Access denied for user

最新推荐文章于 2025-03-05 18:04:21 发布

storm_fury

最新推荐文章于 2025-03-05 18:04:21 发布

阅读量6.4k

点赞数 1

分类专栏： Mysql

本文链接：https://blog.csdn.net/weixin_43215250/article/details/90451927

版权

Mysql 专栏收录该内容

10 篇文章

订阅专栏

博客介绍了MariaDB和MySQL遇到问题时的解决方案。通过修改my.cnf配置文件，在文件末尾加入配置，重启服务后可免密登录数据库，修改密码后，再重新修改配置文件，删除或注释配置并重启服务，最后用新密码登录测试。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

遇到问题

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

解决方案

修改 my.cnf 配置文件
在 /etc/my.cnf 文件末尾加入 skip-grant-tables配置

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd

[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d
#增加下面配置使无密码登录
skip-grant-tables

重启MariaDB服务

[root@cdh01 ~]# systemctl restart mariadb

登录MariaDB

在命令行中,输入 mysql -u root -p命令然后回车，当需要输入密码时，直接按enter键，便可以不用密码登录到数据库当中。
修改密码后，执行flush privileges后退出。

[root@cdh01 yum.repos.d]# mysql -uroot -p
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 5.5.60-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> update mysql.user set password=password("123456") where user="root";
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> flush privileges;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> quit;
Bye

重新修改 my.cnf 配置文件

将skip-grant-tables配置删除或注释掉后，重启mysql服务
```
[root@cdh01 ~]# systemctl restart mariadb
```

利用修改后的密码登录 MariaDB 进行测试

[root@cdh01 ~]# mysql -uroot -p123456
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 5.5.60-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>

MySQL解决方法同上。