Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support MYSQL_SERVER_PUBLIC_KEY #682

Open
methane opened this issue Dec 15, 2023 · 1 comment
Open

Support MYSQL_SERVER_PUBLIC_KEY #682

methane opened this issue Dec 15, 2023 · 1 comment
Milestone

Comments

@methane
Copy link
Member

methane commented Dec 15, 2023

https://dev.mysql.com/doc/c-api/8.0/en/mysql-options.html

MySQL 8.0.33 start deprecating mysql_native_password. Now caching_sha2_password is the default authentication plugin.
When using caching_sha2_password in insecure transport (e.g. TCP without TLS), password must be encrypted with server public key.
The safest way to use the server's public key is to use the MYSQL_SERVER_PUBLIC_KEY option.

MariaDB Connector/C supports MYSQL_SERVER_PUBLIC_KEY since they support sha256_password in 3.0.

@methane methane added this to the v2.3 milestone Dec 15, 2023
@taozuhong
Copy link

MariaDB Connector/C have much more different with MySQL Connector/C, we should consider splitting it into two library now.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants