Fast authentication for `caching_sha2_password`
Open
compatibility-mysql80
component/mysql-protocol
type/compatibility
type/enhancement
- Dominant language
- Go
- Stars
- 40.5k
- Forks
- 6.2k
- PR merge metrics
- PR metrics pending
Description
## Enhancement
The `caching_sha2_password` authentication method supports a "fast authentication" (cached) and a "full authentication". TiDB only supports "full authentication". This issue is to add support for "fast authentication".
https://github.com/pingcap/tidb/blob/c82ba4e083d7578e8f6d22aba3af5bbb71c7ab1d/pkg/server/conn.go#L702-L704
https://dev.mysql.com/doc/dev/mysql-server/latest/page_caching_sha2_authentication_exchanges.html
Previous work: https://github.com/pingcap/parser/pull/1328
Related:
- https://github.com/pingcap/tidb/issues/54138#issuecomment-2426063728
- https://github.com/pingcap/tidb/issues/9411
Contributor guide
Assessment
This issue has not been assessed yet.