[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:  6.7
Component:  Database                            |     Version:
 Severity:  normal                              |  Resolution:
 Keywords:  has-patch fixed-major dev-reviewed  |     Focuses:
------------------------------------------------+---------------------

Comment (by desrosj):

 In [changeset:"59309" 59309]:
 {{{
 #!CommitTicketReference repository="" revision="59309"
 Build/Test Tools: Add MySQL 8.4 support to the Docker environment.

 Because `caching_sha2_password` is not supported on PHP 7.2 & 7.3, the
 local Docker environment has used the `--default-authentication-plugin`
 system variable to always make use of `mysql_native_password` despite
 MySQL 8.0 deprecating this auth plugin.

 However in MySQL 8.4, the `--default-authentication-plugin` option was
 removed in favor of `--authentication-policy`, and `mysql_native_password`
 is now disabled by default. `mysql_native_password` has also been removed
 in MySQL 9.0.

 This change adds support to the local Docker environment for MySQL 8.4 by
 adding some helper functions that determine which authentication plugin
 should be used based on the configured PHP/MySQL versions and
 automatically making the necessary configuration adjustments.

 Reviewed by peterwilsoncc.
 Merges [59279] to the 6.7 branch.

 Props ayeshrajans, johnbillion, aristath, jorbin.
 See #61218.
 }}}

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