[wp-trac] [WordPress Trac] #61218: Preparing for MySQL 8.4 compatibility

[WordPress Trac]

#61218: Preparing for MySQL 8.4 compatibility
-------------------------+-----------------------------
 Reporter:  ayeshrajans  |      Owner:  (none)
     Type:  enhancement  |     Status:  new
 Priority:  normal       |  Milestone:  Awaiting Review
Component:  Database     |    Version:
 Severity:  normal       |   Keywords:
  Focuses:               |
-------------------------+-----------------------------
 MySQL 8.4 was released last month with some potentially breaking changes.
 It's an LTS release, which means that unlikely MySQL innovation branch,
 MySQL 8.4 will likely be included in near future distros as well.

 Among the [https://dev.mysql.com/doc/refman/8.4/en/mysql-nutshell.html
 list of changes] in MySQL 8.4 is that it does not enable the
 `mysql_native_password` plugin by default. If a WordPress site tries to a
 MySQL 8.4 server with a MySQL user that uses this plugin, the connection
 fails unless the user is modified to use a modern plugin, or MySQL is
 configured to load the plugin.

 I wrote about the fixes and approaches [https://php.watch/articles/fix-
 php-mysql-84-mysql_native_password-not-loaded here] as well.

 Errors due to this change look like:

 **PDO:**
 `SQLSTATE[HY000] [1524] Plugin 'mysql_native_password' is not loaded`

 **MySQLi:**
 `mysqli_sql_exception  Plugin 'mysql_native_password' is not loaded.`

 I would like to see if we are willing to:

 1. Show information about potentially deprecated authentication plugins in
 the Site Health page. For example, if the MySQL user is using
 `mysql_native_password` or `sha256_password` (not
 `caching_sha2_password`), we can show a warning to the user.

 2. Automatically attempt to change the auth plugin: It should be trivial
 to update the auth plugin during a maintenance task, but this is likely
 outside of WordPress's responsibility.

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/61218>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform