allowCleartextPasswords - mysql data source

I’m adding a new mysql data source and received the following errors:

This user requires clear text authentication. If you still want to use it, please add ‘allowCleartextPasswords=1’ to your DSN

I tried adding “?allowCleartextPasswords=1” next to the database name, example: DBNAME?allowCleartextPasswords=1, however received following error:

invalid bool value: 1?collation=utf8mb4_unicode_ci

What is the valid bool value or how do we enable clear text password plugin?


Did you ever get this resolved and if so what did you do.