Implement more authenticator types for MySQL and PostgreSQL

[RaigorJiang]

Hi community,

Now Proxy already supports specifying different password authentication methods for users, which provides users with more choices.

We have implemented:

• MySQL
  • mysql_native_password
  • mysql_clear_password
  • caching_sha2_password
• PostgreSQL
  • md5
  • password
• openGauss
  • md5
  • scram-sha-256

Now, there are still the following to be added, and everyone is welcome to participate:

• MySQL
  • [ ] mysql_old_password
  • [ ] authentication_windows_client
• PostgreSQL
  • [ ] scram-sha-256

The configuration in #24313 can be used as a reference:

authority:
  users:
    - user: root@%
      password: root
      authenticationMethodName: md5
    - user: sharding
      password: sharding
  authenticators:
    md5:
      type: MD5

props:
  proxy-frontend-database-protocol-type: openGauss

Refenence

• MySQL Authentication Plugins
• Protocol of MySQL Authentication Methods
• PostgreSQL Password Authentication

[Qianyi951015]

I'll try it

[RaigorJiang]

Welcome @Qianyi951015

[yx9o]

Let me try.