I had a customer who had an error with MySQL ODBC on Monarch Complete 13.1.1 in data prep studio.
He could connect to MySQL community edition 5.5 using ODBC in Monarch Classic but not in Data Prep Studio.
I tested this and had the same error. When I tried it with the latest version (13.2) and it is fixed in that version.
Unfortunately, the MySQL connector we use for Data Prep Studio only supports the Enterprise or Commercial edition.
If you have a MySQL community ODBC driver then you can the ODBC connector instead to connect to the community version of MySQL. Note that this feature is only available for version 13.2 of Complete and Personal.