[QUESTION] I would like to use caching_sha2_password authentication type in a situation where sslMode=DISABLED. (original) (raw)

Summary

I would like to use caching_sha2_password authentication type in a situation where sslMode=DISABLED.

Detailed description

The way I tried it is,

1. sslMode=DISABLED&allowPublicKeyRetrieval=true
   • Failed
2. sslMode=DISABLED&allowPublicKeyRetrieval=true&tcpKeepAlive=true
   • Failed
3. sslMode=DISABLED&allowPublicKeyRetrieval=true&&serverRsaPublicKeyFile=xxx
   • Failed

Relevant context

Error message is,
Caused by: io.r2dbc.spi.R2dbcPermissionDeniedException: Authentication type 'caching_sha2_password' must require SSL in full authentication phase

Your environment

• MySQL version : 8.0.28
• SSL : none

Additional information

SSL cannot be enabled on the DB server.

Checklist

• I have searched the existing issues to make sure my question has not been asked before
• I have provided all the necessary information and context to help answer my question
• I have read the documentation and/or README for this project (if applicable)