[wp-trac] [WordPress Trac] #49307: Is WordPress version 4.9.8 compatible to MySql ver 8.0 and above?

[WordPress Trac]

#49307: Is WordPress version 4.9.8 compatible to MySql ver 8.0 and above?
--------------------------+----------------------
 Reporter:  amitdutt24    |       Owner:  (none)
     Type:  defect (bug)  |      Status:  closed
 Priority:  normal        |   Milestone:
Component:  Database      |     Version:  4.9.8
 Severity:  normal        |  Resolution:  invalid
 Keywords:                |     Focuses:
--------------------------+----------------------
Changes (by SergeyBiryukov):

 * keywords:  MySql update =>
 * severity:  critical => normal
 * milestone:  Awaiting Review =>


Comment:

 Hi there, welcome to WordPress Trac! Thanks for the ticket.

 It should be compatible if you set the `default_authentication_plugin`
 configuration variable to `mysql_native_password` instead of
 `caching_sha2_password`.

 This article might be helpful: [https://www.akamenskiy.com/fix-wordpress-
 database-connection-mysql-8/ How to fix WordPress database connection for
 MySQL 8].


 Related: #38032, #44586, #47280, #48377.

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