相信很多同学用nacos配置mysql时都遇到了这个报错(No DataSource set)

2022-01-22 10:23:25,063 ERROR Application run failed
 
org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'memoryMonitor' defined in URL [jar:file:/F:/Environment/nacos-server-2.0.3/target/nacos-server.jar!/BOOT-INF/lib/nacos-config-2.0.3.jar!/com/alibaba/nacos/config/server/monitor/MemoryMonitor.class]: Unsatisfied dependency expressed through constructor parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'asyncNotifyService': Unsatisfied dependency expressed through field 'dumpService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'externalDumpService': Invocation of init method failed; nested exception is ErrCode:500, ErrMsg:Nacos Server did not start because dumpservice bean construction failure :
No DataSource set
先简单总结一下nacos配置mysql步骤:

新建数据库nacos_config, 执行sql脚本生成表单
在application.properties下配置mysql相关属性
启动
一般都是在配置application.properties文件时出了问题, 如果直接照抄官方文档会报错, 因为mysql8.0之后的版本, 需要在官网文档配置mysql的基础上加上mysql时区的设置

正确的配置如下:

spring.datasource.platform=mysql
 
db.num=1
db.url.0=jdbc:mysql://127.0.0.1:3306/nacos_config?characterEncoding=utf8&serverTimezone=UTC&connectTimeout=1000&socketTimeout=3000&autoReconnect=true
db.user=我的mysql用户名
db.password=我的密码
启动成功!

来源地址：https://blog.csdn.net/m0_64596157/article/details/131604557