lighthouse icon indicating copy to clipboard operation
lighthouse copied to clipboard

Published 20 hours ago • verified publisher icon nuwave

Switch test setup to MySQL 8

Open spawnia opened this issue 3 years ago • 1 comments

The newest Ubuntu 20.04 in GitHub actions is now using MySQL 8: https://github.com/actions/virtual-environments/blob/main/images/linux/Ubuntu2004-README.md#mysql.

MySQL 8.0 requires a new authentication method that is only supported in PHP 7.4+.defaults: Once we drop support for older PHP versions, we can use ubuntu-20.04. Also, default ordering semantics in MySQL 8 seem to have changed, so we will need to change a bunch of assertJson() to assertSimilarJson().

spawnia avatar Apr 04 '21 11:04 spawnia

Should we actually do this though? I can not find other sources, but at least in 2019 the most popular version was still 5.7 - see https://www.eversql.com/mysql-8-adoption-usage-rate.

spawnia avatar Jan 10 '23 11:01 spawnia