Spring Boot Webapp无法连接到MariaDb

Question

1. OS： Windows 10
2. pom.xml配置：Spring Boot：2.0.8 Mariadb：1.5.9 flywaydb：4.2.0
3. Mariadb： 10.2.26

描述：我的Spring Boot webapp无法连接到Mariadb。我已在Mariadb上使用pwd配置根用户，并创建了一个db（测试）

我在Spring Boot应用程序中遇到以下异常

Unable to obtain Jdbc connection from DataSource (jdbc:mysql://localhost:3306/test?useSSL=false&serverTimezone=UTC) for user 'root': Could not connect: Access denied for user 'root'@'localhost' (using password: YES)
Current charset is UTF-8. If password has been set using other charset, consider using option 'passwordCharacterEncoding'
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL State  : 28000
Error Code : 1045
Message    : Could not connect: Access denied for user 'root'@'localhost' (using password: YES)
Current charset is UTF-8. If password has been set using other charset, consider using option 'passwordCharacterEncoding'

1. “root”用户可以使用HeidiSQL登录数据库“test”

spring.test.datasource.url=jdbc:mysql://localhost:3306/test?useSSL=false&serverTimezone=UTC
spring.test.datasource.jdbcUrl=jdbc:mysql://localhost:3306/test?useSSL=false&serverTimezone=UTC
spring.test.datasource.username=john
spring.test.datasource.password=Doe1!

我在电脑上检查了端口号3306，它正在监听。

有人能告诉我为什么应用程序试图登录'root@localhost'? 而不是john@localhost?

Answer 1

由于错误建议您只需要通过正确的密码字符编码与您的连接字符串。

例如：jdbc：mysql://localhost:3306/test?useSSL=false

Answer 2

看起来没有拾取您定义的属性。

https://docs.spring.io/spring-boot/docs/current/reference/html/common-application-properties.htmlspring。数据源。url不是spring。测验数据源。url