Mysql 版本不一致导致Access denied for user’root’@‘localhost’ 问题_ssh com.mysql.cj.exceptions.cjexception: access de-优快云博客

本文链接：https://blog.youkuaiyun.com/yytrobot/article/details/117383130

本文讲述了如何解决因Mysql版本升级导致的'Access denied for user 'root'@'localhost'(using password: YES)'问题，涉及从5.7到8.0的数据库迁移步骤和注意事项，包括安装Mysql 8.0.20并解决启动问题的方法。

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

##解决Mysql 的Access denied for user’root’@‘localhost’ (using password: YES)问题

半年前的项目突然跑不起来了，控制台提示：
java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[mysql-connector-java-8.0.13.jar:8.0.13]
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.13.jar:8.0.13]
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.13.jar:8.0.13]
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:835) ~[mysql-connector-java-8.0.13.jar:8.0.13]
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455) ~[mysql-connector-java-8.0.13.jar:8.0.13]
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240) ~[mysql-connector-java-8.0.13.jar:8.0.13]
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:207) ~[mysql-connector-java-8.0.13.jar:8.0.13]
at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:156) ~[druid-1.1.17.jar:1.1.17]
at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:218) ~[druid-1.1.17.jar:1.1.17]
at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:150) ~[druid-1.1.17.jar:1.1.17]
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1598) ~[druid-1.1.17.jar:1.1.17]
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1662) ~[druid-1.1.17.jar:1.1.17]
at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:932) ~[druid-1.1.17.jar:1.1.17]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_221]
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_221]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_221]
at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_221]

初步分析是数据库版本不匹配问题，pom.xml中使用mysql-connector-java-8.0.13.jar包，而本地数据库是5.7版本。因此，先删除5.7版本的Mysql,安装Mysql8.0.20后，启动项目成功。
Mysql8.0.20安装方法，可参考：https://www.cnblogs.com/zhukf/p/11976855.html
注意：安装服务后，如果在命令行下启动不了mysql服务，可重启电脑，由操作系统启动mysql服务