未使用Spring Boot JPA实体的表数据填充MSQLWorkbench

Question

spring.jpa.hibernate.ddl-auto=create
spring.datasource.url=jdbc:mysql://localhost:3306/TestSchema
spring.datasource.username=*****    
spring.datasource.password=*****
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.MySQL5Dialect
spring.jpa.database = MYSQL

java.sql.SQLException: Access denied for user 'dougwb'@'localhost' (using password: YES). 

虽然这是我配置的用户名，但YES不是我在application.properties文件中提供的密码，也不是我的MySQL工作台密码。如何正确配置Spring Boot应用程序来识别我的MySQL工作台，并用User@Entity JPA注释自动填充TestSchema数据库？

Answer 1

在线讨论的结论。

根据Spring Boot官方文档，JDBC驱动程序将被自动检测。

spring.datasource.driver-class-name = # Fully qualified name of the JDBC driver. Auto-detected based on the URL by default.

向MySQL用户授予特权，并使用mysql_native_password进行默认身份验证。

GRANT ALL PRIVILEGES ON * . * TO 'user_name'@'localhost'; 
ALTER USER 'user_name'@'localhost' IDENTIFIED WITH mysql_native_password BY 
'user_name';

spring.datasource.url=jdbc:mysql://localhost:3306/TestSchema?useUnicode=true&cha‌​racterEncoding=UTF-8&allowPublicKeyRetrieval=true&useSSL=false