How to authenticate using cleartext?

[kpeters-cbsi]

I'd like to use @databases to connect to an Amazon RDS proxy. The proxy uses IAM authentication, which requires the use of the mysql_clear_password authentication plugin. I don't see anything in the docs about authentication plugins. Can you help?

See https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.IAMDBAuth.Connecting.AWSCLI.html for an example of using the MySQL CLI to connect to an RDS instance with IAM authentication.

[ForbesLindesay]

If anyone can provide a sample of how to do this using the underlying mysql2 library, I'd be happy to take a look at this. Better yet, someone could provide a pull request for this.

[kpeters-cbsi]

Looking at my code that's connecting to the RDS proxy, it looks like all I'm doing is this:

import { createConnection } from 'mysql2/promise';

let connection = await createConnection({ host: 'MyProxyHostname', user: 'MyUsername', password: 'MyPassword', port: 3306, ssl: 'Amazon RDS' });
// do stuff w/ connection