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

分类: 文章 • 2024-05-12 17:19:52

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

需要重置密码

1.首先输入以下命令

#vim /etc/my.cnf(注：windows下修改的是my.ini)
ERROR 1045 (28000): Access denied for user ‘root‘@‘localhost‘ (using password: YES)

在[mysqld]后面任意一行添加“skip-grant-tables”用来跳过密码验证的过程，如下图所示
ERROR 1045 (28000): Access denied for user ‘root‘@‘localhost‘ (using password: YES)
保存并退出

设置新密码
ERROR 1045 (28000): Access denied for user ‘root‘@‘localhost‘ (using password: YES)
重启

登录