DB container not starting with current docker-compose.example.yml file

[jelkose]

After updating my local environment, the db-container did not start anymore. The following error is displayed: [Server] unknown variable 'default-authentication-plugin=mysql_native_password'. The update pulled the newest version of mysql:8 (which stands in docker-compose.example.yml) from docker, which currently is 8.4. In this version the native password plugin was removed (see https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-0.html).

A workaround is to replace the --default-authentication-plugin=mysql_native_password flag in https://github.com/standardnotes/server/blob/dbb0e4a9746c022126e719ddbcd31cec9fca12aa/docker-compose.example.yml#L42 by --mysql-native-password=ON which enables the native password plugin again (see https://dev.mysql.com/doc/refman/8.4/en/native-pluggable-authentication.html). But as this plugin is deprecated and will be removed completely in future releases, I think using a more up-to-date authentication plugin would be better.

Cheers, Jelko