Reports

these my settings for solving this problem:

part1:

<dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>8.0.33</version> 
        <scope>runtime</scope>
    </dependency>

part2:

MySQL database connection settings

spring.datasource.url=jdbc:mysql://localhost:3306/database_name

spring.datasource.username=root

spring.datasource.password=

spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

Hibernate (JPA) settings

spring.jpa.hibernate.ddl-auto=update

spring.jpa.show-sql=true

spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL8Dialect

part3: if you are using intelliJ, ensure reload all maven projects

enter image description here

79118480