GitDocs
Database version contract drift

MySQL 8.4 mysql_native_password disabled default authentication plugin caching_sha2_password documentation

A current MySQL 8.4 task fails with: Node `mysql2` `ER_NOT_SUPPORTED_AUTH_MODE` with MySQL 8.4.

search-observedMySQL 8.4Database server and driversDatabase version contract driftgitdocs_candidate100

Agent Quick Fix

The local workspace gives the symptom and stale integration shape, but the correct repair depends on current official product behavior or recent release notes.

Product: MySQL 8.4
Current-contract area: Node `mysql2` `ER_NOT_SUPPORTED_AUTH_MODE` with MySQL 8.4
Likely root cause: A current MySQL 8.4 task fails with: Node `mysql2` `ER_NOT_SUPPORTED_AUTH_MODE` with MySQL 8.4. The local stale integration is plausible but may not reflect the current external contract.
Repair direction: Verifier accepts a repair record only if it states the current contract and an actionable fix using source-backed product terms.

Validation Status

Codex searched organically, but the no-web counterfactual also passed under this fixture. Treat this as search-observed query evidence, not proof that search was necessary.

Symptom

A current MySQL 8.4 task fails with: Node `mysql2` `ER_NOT_SUPPORTED_AUTH_MODE` with MySQL 8.4. The local stale integration is plausible but may not reflect the current external contract.

Why This Happens

The local workspace gives the symptom and stale integration shape, but the correct repair depends on current official product behavior or recent release notes.

Verification

Verifier accepts a repair record only if it states the current contract and an actionable fix using source-backed product terms.

Common Wrong Fixes

  • Changing local code without checking the current external contract.
  • Retrying the same install, build, or API call with no version/source change.
  • Applying a broad unsafe bypass when a narrow compatibility fix is available.

Codex Search Keywords

These are the search terms observed in a neutral Codex validation run for this failure shape.

MySQL 8.4 mysql_native_password disabled default authentication plugin caching_sha2_password documentation
site:dev.mysql.com/doc/refman/8.4 mysql_native_password 8.4 disabled
https://dev.mysql.com/doc/refman/8.4/en/native-pluggable-authentication.html
'caching_sha2_password is the default authentication plugin' in https://dev.mysql.com/doc/refman/8.4/en/caching-sha2-pluggable-authentication.html
mysql2 caching_sha2_password support GitHub mysql2 documentation
https://github.com/sidorares/node-mysql2
https://sidorares.github.io/node-mysql2/docs/documentation/authentication-switch
'caching_sha2_password' in https://github.com/sidorares/node-mysql2/blob/master/Changelog.md

Source Trail

GitHub source file/reference: