[wp-trac] [WordPress Trac] #48377: sql_mode ANSI is incompatible with WP in MySQL 5.7.5+

[WordPress Trac]

#48377: sql_mode ANSI is incompatible with WP in MySQL 5.7.5+
--------------------------+---------------------
 Reporter:  jnylen0       |       Owner:  (none)
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  5.4
Component:  Database      |     Version:
 Severity:  normal        |  Resolution:
 Keywords:                |     Focuses:
--------------------------+---------------------

Comment (by williampatton):

 Also running into this same issue here caused by changes with ANSI in
 various different MySQL servers. MySQL 8 installs are becoming more common
 (this is what I think runs at DO managed DB service) and this issue
 affects those users on default installs of mysql 8. It is wher eI have
 faced this same issue anyway but I  guess it's from mysql 5.7.5 onward.

 Since frequency I am seeing this has increased I think we should tackle
 this ASAP. The 5.4 milestone seems reasonable but pushing back any longer
 than that I would be worried.

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