What did you do?

Started a migration task from MariaDB 10.6.13 using TiUP playground and a Dockerized MariaDB source. The DM task failed during pre-checks due to invalid privilege-check logic.

(step-by-step attached)
README.md

What did you expect to see?

DM should detect MariaDB and skip incompatible GRANT statements or use MariaDB-compatible syntax.

What did you see instead?

Multiple privilege checks failed due to invalid syntax in MariaDB.

"short_error": "line 1 column 64 near \"MONITOR ON *.* TO `tidb-dm`@`%` IDENTIFIED BY PASSWORD '*F140AD44180E4713D0DDC2FE46ADF5DBBACA16EE'\" "

This failed for:

• source db dump privilege checker
• source db replication privilege checker
• dumper_conn_number_checker

Versions of the cluster

DM version:
v8.5.2

Upstream MySQL/MariaDB:
10.6.13-MariaDB-1:10.6.13+maria~ubu2004 mariadb.org binary distribution

Downstream TiDB:
v8.5.2

Deployed with TiUP

current status of DM cluster (execute query-status <task-name> in dmctl)

{
"id": 4,
"name": "source db dump privilege checker",
"desc": "check dump privileges of source DB",
"state": "fail",
"errors": [
{
"severity": "fail",
"short_error": "line 1 column 64 near "MONITOR ON . TO tidb-dm@% IDENTIFIED BY PASSWORD '*F140AD44180E4713D0DDC2FE46ADF5DBBACA16EE'" "
}
],
"extra": "address of db instance - 127.0.0.1:3306"
},