EMQX5.3 数据桥接mysql 连接错误 400 TEST_FAILED:unhealthy_target

EMQX5.3 数据桥接mysql 连接错误 400 TEST_FAILED:unhealthy_target,其他功能正常

求助,什么原因

就是连上不你的mysql啊,你看看emqx 的日志,有具体的报错原因的。

缺一张表
CREATE TABLE t_mqtt_msg (
id int NOT NULL AUTO_INCREMENT,
msgid varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
sender varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
topic varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
qos int DEFAULT NULL,
retain int DEFAULT NULL,
payload text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
arrived timestamp NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

你的数据库连上了吗
,怎么做的