会出现java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES),此时给0000加个单引号变为'0000'则登陆成功,根本原因还是因为密码错误。 yml文件上对于纯数字类型的密码需要加引号,如果是包含字母的就不需要。
2019-04-09 10:09:36 [Druid-ConnectionPool-Create-2053591126] [ com.alibaba.druid.pool.DruidDataSource ] [ 53 ] [ ERROR ] create connection SQLException, url: jdbc:mysql://*.*.*.*:3306/*?characterEncoding=utf-8&useSSL=false, errorCode 1045, state 28000 java.sql.SQLException: Access de...
异常信息如下(隐藏了db信息): create connection SQLException, url: jdbc:mysql:///, errorCode 1045, state 28000 java.sql.SQLException: Access denied for user ''@'***' (using password: YES) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964) at com.mysql.jdbc.MysqlIO.checkError...
characterEncoding=utf-8&useSSL=false, errorCode 1045, state 28000 java.sql.SQLException: Access denied for user 'malluser'@'*.*.*.*' (using password: YES) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:545) ~[mysql-connector-java-6.0.6.jar:6.0.6] at com....
2022-02-09 11:04:58.896 ERROR 16876 --- [eate-1550991149] com.alibaba.druid.pool.DruidDataSource : create connection SQLException, url:jdbc:mysql://47.98.67,98:1234/test?useSSL=false&characterEncoding=UTF-8&serverTimezone=UTC, errorCode 1045, state 28000 ...
2022-02-09 11:04:58.896 ERROR 16876 --- [eate-1550991149] com.alibaba.druid.pool.DruidDataSource : create connection SQLException, url: jdbc:mysql://47.98.67,98:1234/test?useSSL=false&characterEncoding=UTF-8&serverTimezone=UTC, errorCode 1045, state 28000 ...
2022-02-09 11:04:58.896 ERROR 16876 --- [eate-1550991149] com.alibaba.druid.pool.DruidDataSource : create connection SQLException, url: jdbc:mysql://47.98.67,98:1234/test?useSSL=false&characterEncoding=UTF-8&serverTimezone=UTC, errorCode 1045, state 28000 ...
如视频文件的上传这时候可以测试可以知道数据库信息入库失败，日志提示数据库连接失败：2018-01-17 15:10:20.481 ERROR 1144 --- [Create-15674126] com.alibaba.druid.pool.DruidDataSource : create connection SQLException, url: jdbc:mysql://127.0.0.1:3306/videoDB, errorCode 1045, state 28000java....
2022-02-09 11:04:58.896 ERROR 16876 --- [eate-1550991149] com.alibaba.druid.pool.DruidDataSource : create connection SQLException, url: jdbc:mysql://47.98.67,98:1234/test?useSSL=false&characterEncoding=UTF-8&serverTimezone=UTC, errorCode 1045, state 28000 ...
springboot集成druid登陆mysql发生errorCode 1045, state 28000错误 2019-08-30 02:32 −... ST没有C 1 14630 springboot 整合druid,使用postgresql 2019-11-28 15:41 −1.首先引入相关依赖 <dependency> <groupId>com.alibaba</groupId> <artifactId>druid-spring-boot-starter</artifactId> <version......