[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:  6.1
Component:  Database      |     Version:  5.4
 Severity:  normal        |  Resolution:
 Keywords:  needs-patch   |     Focuses:
--------------------------+---------------------

Comment (by SergeyBiryukov):

 Thanks for the ticket!

 > PHP 5.6 / MySQL 8.0 / WP 5.5 and latest (5.6)
 >
 > {{{
 > PHP Warning:  mysqli_real_connect(): Server sent charset (255) unknown
 to the client. Please, report to the developers in /tmp/wordpress/wp-
 includes/wp-db.php on line 1653
 > PHP Warning:  mysqli_real_connect(): (HY000/2054): Server sent charset
 unknown to the client. Please, report to the developers in /tmp/wordpress
 /wp-includes/wp-db.php on line 1653
 > PHP Warning:  mysql_connect(): Server sent charset (255) unknown to the
 client. Please, report to the developers in /tmp/wordpress/wp-includes/wp-
 db.php on line 1685
 > PHP Warning:  mysql_connect(): Server sent charset unknown to the
 client. Please, report to the developers in /tmp/wordpress/wp-includes/wp-
 db.php on line 1685
 > }}}
 >
 > PHP 7.0 - 7.3 / MySQL 8.0 / WP latest (5.6)
 >
 > {{{
 > PHP Warning:  mysqli_real_connect(): The server requested authentication
 method unknown to the client [caching_sha2_password] in /tmp/wordpress/wp-
 includes/wp-db.php on line 1653
 > PHP Warning:  mysqli_real_connect(): (HY000/2054): The server requested
 authentication method unknown to the client in /tmp/wordpress/wp-includes
 /wp-db.php on line 1653
 > }}}


 I could not reproduce the charset issues yet, but I was able to reproduce
 the issue with `caching_sha2_password` and confirm the observations from
 comment:3:

 > 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`?

 This resolves the second issue in my testing.

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