切换数据库为mysql，报错[1064] [42000] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'READ ONLY' at line 1

[a141178]

Caused by: io.r2dbc.spi.R2dbcBadGrammarException: [1064] [42000] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'READ ONLY' at line 1
at io.asyncer.r2dbc.mysql.message.server.ErrorMessage.toException(ErrorMessage.java:113)
at io.asyncer.r2dbc.mysql.AbstractTransactionState.accept(QueryFlow.java:886)
at io.asyncer.r2dbc.mysql.TransactionBatchExchangeable.accept(QueryFlow.java:1150)
at io.asyncer.r2dbc.mysql.TransactionBatchExchangeable.accept(QueryFlow.java:1140)
...6 frames excluded
at io.asyncer.r2dbc.mysql.client.ReactorNettyClient$ResponseSink.next(ReactorNettyClient.java:395)
at io.asyncer.r2dbc.mysql.client.ReactorNettyClient.lambda$new$0(ReactorNettyClient.java:119)
...26 frames excluded

Process finished with exit code 1

`# 数据库相关配置
DB_HOST: 192.168.1.196
DB_PORT: 3306
DB_DATABASE: jetlinks
DB_USERNAME: root
DB_PASSWORD: 123456
DB_SCHEMA: jetlinks
DB_DIALECT: mysql

redis 相关配置

REDIS_HOST: 192.168.1.49
REDIS_PORT: 6379 # redis 数据库地址
REDIS_PASSWORD: "" # redis 密码
REDIS_DATABASE: 0 # redis 数据库索引

timescalbedb相关配置

TIMESCALEDB_SCHEMA: public # timescaledb 数据库schema,默认public

elasticsearch相关配置

ES_URIS: 127.0.0.1:9200
ES_USERNAME: "" # elasticsearch 用户名
ES_PASSWORD: "" # elasticsearch 密码
`

[zhou-hao]

麻烦提供一下完整错误日志