xxl-job mysql 8.0初始化报语法错误

m1m5dgzv 于 9个月前发布在 Mysql

关注(0)|答案(1)|浏览(259)

Please answer some questions before submitting your issue. Thanks!

Which version of XXL-JOB do you using?

v2.2.0

Expected behavior

不报错

Actual behavior

17:28:32 CHARSET=utf8mb4 Error Code: 1064. 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 'CHARSET=utf8mb4' at line 1 0.047 sec

Steps to reproduce the behavior

mysql 8.0 CE on wsl 2 ubuntu 64

Other information

mysql workbench 8.0 CE

xxl-job

来源：https://github.com/xuxueli/xxl-job/issues/2426

1条答案

按热度按时间

u1ehiz5o1#

去掉=号，将所有CHARSET=utf8mb4;改为CHARSET utf8mb4;即可。

赞(0）回复(0）举报 9个月前

我来回答