[wp-trac] [WordPress Trac] #52496: Improve MySQL 8.0 support

[WordPress Trac]

#52496: Improve MySQL 8.0 support
--------------------------+---------------------
 Reporter:  jrf           |       Owner:  (none)
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  5.8
Component:  Database      |     Version:  5.4
 Severity:  normal        |  Resolution:
 Keywords:                |     Focuses:
--------------------------+---------------------

Comment (by ayeshrajans):

 Re: PHP 7.0 - 7.3 / MySQL 8.0 / WP latest (5.6)

 PHP <= 7.3 does not support `caching_sha2_password`, so it required
 `--default-authentication-plugin=mysql_native_password` at mysql process
 init, or changing the user authentication plugin to
 `mysql_native_password` for MySQL 8 to work. This should not a problem in
 PHP 7.4 with `caching_sha2_password` built-in. Related:
 https://php.watch/articles/PHP-7.4-MySQL-8-server-gone-away-fix.

 In a CI setup using MySQL 8 + PHP 7.0..7.3, perhaps we can use an init
 option `--default-authentication-plugin=mysql_native_password`?

 I'm not sure about the charset issue. My wild guess is that it's related
 to `utf8mb4_0900_*` class of collations only available in MySQL 8 and is
 the default now.

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