MySQL ER_NOT_SUPPORTED_AUTH_MODE

Radzen Studio Angular
1

Hello,

I'm using MySQL 8 as database, and when I try to configure the datasource, I get the error ER_NOT_SUPPORTED_AUTH_MODE

I have changed the authentication method to legacy, but still get the error.

Has somebody encountered this?

2

Besides changin the Auth Method to legacy, I had to delete and create the schema (database) and with that it worked.

3

Hi @fcovecino,

Indeed the nodejs mysql driver doesn't support MySQL 8 out of the box. Radzen uses that driver to connect in design time (to infer the database schema). We look into finding a workaround.