mysql数据源配置链接方式
2021-07-27 本文已影响0人
拄杖忙学轻声码
一、db.url=jdbc:mysql://127.0.0.1:3306/xxx数据库名称?characterEncoding=utf8&connectTimeout=1000&socketTimeout=3000&autoReconnect=true&serverTimezone=UTC
二、jdbc:mysql://xxx:3306/xxx数据库名称?useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT
三、jdbc:mysql://127.0.0.1:3306/库名?useUnicode=true&characterEncoding=utf8&characterSetResults=utf8&serverTimezone=UTC
四、带允许检索公匙参数(mysql8.0.x需要)
jdbc:mysql://localhost:3306/seata_order?useUnicode=true&characterEncoding=UTF-8&useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=GMT