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

小鱼儿 2023-06-07 03:17 28阅读 0赞

服务器上刚装的 mysql 结果一连接就出了 bug，尴尬……  
  其中安装教程用的是 [CentOS 7 安装 MySQL][CentOS 7 _ MySQL] ,输入登录命令 **mysql -u root -p**，然后，然后就直接挂了。

接下来参考网上教程，建议修改配置文件，跳过密码权限验证，修改密码，再注释掉刚才的修改。

*  进入 **/etc/my.cnf** 文件，找到 **\[mysqld\]** ，在其后面添加 **skip-grant-tables**

vi /etc/my.cnf

![alt][]

*  重启mysql

# systemctl restart mysqld
    
    另：
    查看mysql状态
    # systemctl status mysqld
    停止mysql服务
    # systemctl stop mysqld

*  直接在界面中输入 **mysql** 免密登录数据库，然后输入一下sql语句更改密码。

ALTER USER 'root'@'localhost' IDENTIFIED BY 'My_new_password@123!';

*  一般执行完上面一句会报如下错误，直接在 mysql 中继续输入 **flush privileges**。

ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

*  再次重置密码即可
 *  回到 **/etc/my.cnf** 文件，找到 **\[mysqld\]** ，将其后面添加的 **skip-grant-tables** 删除或者直接注释掉。
 *  重启mysql

# systemctl restart mysqld

*  重新登录数据库，搞定

# mysql -u root -p

参考文章：【1】[centos7下mysql初始密码修改的两种方法][centos7_mysql]  
     【2】[ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statemen - 小浪鼓 - 博客园][ERROR 1290 _HY000_ The MySQL server is running with the --skip-grant-tables option so it cannot execute this statemen - _ -]  
     【3】[解决mysql出现ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES/NO)【Mac】][mysql_ERROR 1045 _28000_ Access denied for user _root_localhost_ _using password_ YES_NO_Mac]

[CentOS 7 _ MySQL]: https://blog.csdn.net/qq_39564555/article/details/98473590
[alt]: /images/20230601/abde2389796749509738183574b430b6.png
[centos7_mysql]: https://blog.csdn.net/zzzcl112/article/details/80484495
[ERROR 1290 _HY000_ The MySQL server is running with the --skip-grant-tables option so it cannot execute this statemen - _ -]: https://www.cnblogs.com/iosdev/archive/2013/07/15/3190431.html
[mysql_ERROR 1045 _28000_ Access denied for user _root_localhost_ _using password_ YES_NO_Mac]: https://blog.csdn.net/qq_33404395/article/details/82990591

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

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

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

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

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

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

相关 HIVE-ERROR 1045 (28000): Access denied for user 'root'@'%' (using password: YES)

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

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

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

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

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