I wrote a CTE like this (a simple CTE example to reproduce the problem):
:::sql with c as (select "Hello") select count(1) from c
On my local machine (mariadb, identical to mysql), it worked.
However here I got this:
ERROR 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 'c as (select "Hello") select count(1) from c' at line 1