NOT_SUPPORTED_AUTH_MODE error when trying to connect via local lamba function

Hi,

I can connect to my DO managed DB via SQL workbench without issue. However, when I try and connect via my local lambda Node JS code, I receive the following error…

An Error… { Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client code: ‘ER_NOT_SUPPORTED_AUTH_MODE’, errno: 1251, sqlMessage: ‘Client does not support authentication protocol requested by server; consider upgrading MySQL client’, sqlState: ‘08004’, fatal: true }

… my mysql looks like so…

   mysql.createConnection({
        host     : removed_for_post,
        user     : process.env["DO_u"],
        password : process.env["DO_p"],
        port     : '25060',
        database : 'defaultdb',
        ssl_mode: 'REQUIRED',
        ssl  : {
            ca : fs.readFileSync('./ca-certificate.txt')
          }

… and I have updated to latest mysql library. I’ve also tried connecting without the ssl_mode and ssl options, same error message.

Any ideas?