Skip to content

expire_logs_days MySQL config option has been removed in MySQL 8.4 #114

Closed

Description

@BrookeDot

MySQL 8.4 fails to start: expire_logs_days in config/mysql8.cnf

expire_logs_days was deprecated in MySQL 8.0 and removed in 8.2 (WL#10924). It still works on mysql:8.0, which is why the default setup isn't affected.

Summary

With database: mysql:8.4, the database service exits right after starting. The recipe's config/mysql8.cnf sets expire_logs_days = 10 (line 52). MySQL removed that variable in 8.2, so 8.4 treats it as unknown and aborts at startup.

Suggested fix

The recipe mounts ~/.lando/config/laravel/mysql8.cnf at /opt/bitnami/mysql/conf/my_custom.cnf. That file (config/mysql8.cnf on main, line 52) contains:

expire_logs_days = 10

Replace it with the 8.0+ equivalent, which also works on 8.0:

binlog_expire_logs_seconds = 864000

This is the same change as lando/lamp#108.

Related

The same expire_logs_days problem has been reported in other recipes:

#109 ("Mysql 8.4 Support") was closed by #108, which removed the hard-coded mysql_native_password. That PR didn't change expire_logs_days, so mysql:8.4 still fails to start with this recipe.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions