prisma: `Error querying the database: Unknown authentication plugin 'mysql_clear_password'.`

Problem

Getting “Error querying the database: Unknown authentication plugin `mysql_clear_password’.” when trying to connect to an AWS RDS proxy (I can connect fine in other clients with proxy and I can connect fine with prisma directly to the database).

Think its because you have to send the password a certain way when using the mysql_clear_password plugin

Suggested solution

I couldn’t find where we make mysql connections in the project (didn’t spend a lot of time looking), but we need add a way to switch auth when making a connection.

mysql2 has the ability to do this with the authPlugins or on the connection config itself as authSwitchHandler. See below which I got from here https://gist.github.com/btbytes/cf1a1e4a90582924833f4d0a15acc1e9

connectionConfig.authSwitchHandler = (data, cb) => {
  if (data.pluginName === 'mysql_clear_password') {
	// See https://dev.mysql.com/doc/internals/en/clear-text-authentication.html
	console.log("pluginName: "+data.pluginName);
	let password = token + '\0';
	let buffer = Buffer.from(password);
	cb(null, password);
  }
};

I don’t think there is alternative solution using prisma