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?