Exception in thread “main“ java.lang.RuntimeException: java.sql.SQLException: Access denied...解决方法

原创于 2023-09-24 22:31:31 发布 · 2.6k 阅读

19 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#java #经验分享 #笔记

编程问题解决专栏收录该内容

1 篇文章

订阅专栏

文章讲述了在使用MybatisPlusAutoGenerator时遇到的运行时异常，原因是数据库连接时权限问题。解决方法是确保在配置文件中设置了正确的数据库连接密码。

Exception in thread “main” java.lang.RuntimeException: java.sql.SQLException: Access denied for user ‘root’@‘localhost’ (using password: YES)
at com.baomidou.mybatisplus.generator.config.DataSourceConfig.getConn(DataSourceConfig.java:170)
at com.baomidou.mybatisplus.generator.config.builder.ConfigBuilder.(ConfigBuilder.java:110)
at com.baomidou.mybatisplus.generator.AutoGenerator.execute(AutoGenerator.java:96)
at com.onlinestudy.generator.ContentCodeGenerator.main(ContentCodeGenerator.java:114)
Caused by: java.sql.SQLException: Access denied for user ‘root’@‘localhost’ (using password: YES)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:835)
at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:455)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at com.baomidou.mybatisplus.generator.config.DataSourceConfig.getConn(DataSourceConfig.java:168)
… 3 more

问题原因：未给数据库连接设置密码，或者设置密码不正确
解决方法：给数据库设置正确的密码
如下图所示：