求助：通过application.yml配置创建数据库Schema失败

Hey there, let's walk through why your Hibernate/MySQL schema setup isn't working as expected. I've spotted a few common issues in your config that might be causing the problem:

1. Outdated MySQL Driver Class #

The com.mysql.jdbc.Driver is the legacy driver for MySQL 5.x and below. If you're using MySQL 8.0+, this driver won't work properly—you need to switch to the new driver class:

driver-class-name: com.mysql.cj.jdbc.Driver

This is one of the most frequent culprits for database connection/schema creation failures with modern MySQL versions.

2. Verify Database Permissions #

Even with createDatabaseIfNotExist=true, your root user needs the CREATE privilege on the MySQL server to create the database. Double-check that your user has the necessary permissions (you can run SHOW GRANTS FOR 'root'@'localhost'; in MySQL CLI to confirm).

3. Hibernate DDL-Auto Behavior #

Your ddl-auto: update setting tells Hibernate to update existing tables, but it relies on the database already existing (or being created by the createDatabaseIfNotExist flag). If the database isn't being created first, Hibernate can't generate tables. Fixing the driver class should resolve this chain issue.

4. Clean Up URL Parameters #

Some of your URL parameters are redundant or deprecated for MySQL 8+:

• useJDBCCompliantTimezoneShift and useLegacyDatetimeCode are no longer needed when using serverTimezone=UTC with the new driver.
• Simplify your URL to make it easier to debug:

url: jdbc:mysql://localhost:3306/schema?useUnicode=true&createDatabaseIfNotExist=true&serverTimezone=UTC

Fixed Configuration Example #

Here's the revised application.yml with the key fixes:

spring:
  jpa:
    hibernate:
      ddl-auto: update
      show-sql: true
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    username: root
    password: 1234
    url: jdbc:mysql://localhost:3306/schema?useUnicode=true&createDatabaseIfNotExist=true&serverTimezone=UTC
server:
  port: 7070

Additional Checks #

• Make sure your mysql-connector-java dependency version matches your MySQL server version (for MySQL 8+, use version 8.0.x or higher in your pom.xml/build.gradle).
• Confirm MySQL server is running on localhost:3306—sometimes it's bound to a different IP or port.
• Check your application logs for specific error messages (Hibernate/Spring Boot will usually log why the schema creation failed, like connection errors or permission issues).

内容的提问来源于stack exchange，提问作者Eran Asaraf