com.mysql.cj.exceptions时URL 与 driver-class-name 可能遇到的问题

编译出现：

Cannot load connection class because of underlying exception:
com.mysql.cj.exceptions.WrongArgumentException: Malformed database
URL, failed to parse the connection string near
‘;characterEncoding=utf-8&useSSL=false’.

SpringBoot连接 版本8.00+的mysql数据库时 URL 与 driver-class-name 可能遇到的问题

原yml中的配置：

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/数据库名
    username: root
    password: 123456
    driver-class-name: com.mysql.jdbc.Driver

改：

#yaml文件中
spring:
  datasource:
    username: root
    password: 123456
    url: jdbc:mysql://localhost:3306/数据库名?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT
    driver-class-name: com.mysql.cj.jdbc.Driver

测试代码：

@Mapper
public interface testDao {

    @Select("select username from user where u_id = #{id}")
    public String findName(String id);
}

    @Test
    void testMyBatis(){
      String name =  testDao.findName("2727cfb1861311eb97d398838947d751");
      System.out.println(name);
    }

若在ssm中可以使用如下：

/*propertise文件中*/
url = "jdbc:mysql://localhost:3306/blog?serverTimezone=Asia/Shanghai&characterEncoding=utf-8&useSSL=false"
driverClassName = "com.mysql.cj.jdbc.Driver"