Hi,
Can you check that “Enable multiple queries” is checked in the datasource definition you are using?
See Troubleshooting mySQL database installs for more information and troubleshooting.
If that doesn’t help, could you sure a few more details like ACF/Lucee and MySQL version please?
Cheers