欢迎使用普元产品知识库,本知识库包含普元应用开发平台EOSPlatform,流程平台BPS,企业服务总线ESB,微服务平台Microservice,运维管理平台Devops,数据集成平台DI
欢迎使用普元文档库
后端业务应用productmanage的application.yml里配置使用xx.xx.xx.214上安装的mysql数据库,但启动该应用时,提示连接不上xx.xx.xx.223上的mysql数据库,实际连接的数据库IP地址跟配置的不一致,导致启动报错
2020-02-25 12:39:23.608 ERROR [StudySys,PRODUCT-MANAGE,default,10.15.15.223:PRODUCT-MANAGE:8882,,,,] 20971 --- [Druid-ConnectionPool-Create-539425791] com.alibaba.druid.pool.DruidDataSource : create connection SQLException, url: jdbc:mysql://xx.xx.xx.214:3306/eos_product_manage_master?serverTimezone=UTC&useUnicode=true&characterEncoding=UTF-8&useSSL=false&allowMultiQueries=true, errorCode 1045, state 28000
java.sql.SQLException: Access denied for user 'platform_a'@'xx.xx.xx.223' (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.<init>(ConnectionImpl.java:455)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:207)
at com.mysql.cj.jdbc.Driver.connect$accessor$1B43SMUL(Driver.java)
at com.mysql.cj.jdbc.Driver$auxiliary$UZGFdznP.call(Unknown Source)
......
application.yml中配置的数据地址:
url: jdbc:mysql://xx.xx.xx.214:3306/eos_product_manage_master?serverTimezone=UTC&useUnicode=true&characterEncoding=UTF-8&useSSL=false&allowMultiQueries=true
username: platform_a
password: Aa#123456
问题原因:application.yml中数据库密码格式书写不正确导致;
解决方式:1、将Aa#123456用单引号括起来,改为:'Aa#123456'
2、重新启动应用不再报上述错误