PHP 8.3 / MySQL 8.4 / PDO / caching_sha2_password

[dwilbourne]

Description

Not sure if this is implemented (yet):

Does the PDO to MySQL driver support the caching_sha2_password authentication plugin? I can see that the native mysqli works (e.g. I can connect over SSL using sha2 encrypted password), but I get an exception trying to create a PDO connection using caching_sha2_password.

PDOException : SQLSTATE[HY000] [1524] Plugin 'mysql_native_password' is not loaded.

Thanks in advance

PHP Version

PHP 8.3.12 (MySQL 8.4)

Operating System

Windows 10 - not sure if it is relevent

[cmb69]

This is a bit confusing (for me), since caching_sha2_password and mysql_native_password are supposed to be two different plugins (I don't think either relies on the other).

[SakiTakamachi]

Maybe the following PR's discussion is related:
#14118

[dwilbourne]

My apologies - I had not completely read the documentation. PDO/caching_sha2_password works correctly over an SSL connection. Though the options for the PDO driver are not exactly like the mysqli driver, you do need to pass options as the last argument in the construction of the connection and I had not done that. Sorry to take your time and thank you for all you do making PHP such a great environment.