MySQL 8.4 fails to start using LEMP or WordPress recipe

[webbedfeet-stu]

I'm not 100% whether to put this issue here or in the lando/lemp repo.

When using mysql:8.4, the database fails to start throwing the following errors:

2025-01-15T12:18:39.587023Z 0 [System] [MY-015017] [Server] MySQL Server Initialization - start.
2025-01-15T12:18:39.589709Z 0 [System] [MY-013169] [Server] /opt/bitnami/mysql/bin/mysqld (mysqld 8.4.3) initializing of server in progress as process 83
2025-01-15T12:18:39.678385Z 0 [Warning] [MY-013907] [InnoDB] Deprecated configuration parameters innodb_log_file_size and/or innodb_log_files_in_group have been used to compute innodb_redo_log_capacity=209715200. Please use innodb_redo_log_capacity instead.
2025-01-15T12:18:39.679940Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-01-15T12:18:39.971610Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2025-01-15T12:18:42.230737Z 0 [ERROR] [MY-000067] [Server] unknown variable 'default_authentication_plugin=mysql_native_password'.
2025-01-15T12:18:42.231042Z 0 [ERROR] [MY-013236] [Server] The designated data directory /bitnami/mysql/data/ is unusable. You can remove all files that the server added to it.
2025-01-15T12:18:42.231068Z 0 [ERROR] [MY-010119] [Server] Aborting
2025-01-15T12:18:43.423350Z 0 [System] [MY-015018] [Server] MySQL Server Initialization - end.

It looks like its failing to start because in 8.4, there is no default-authentication-plugin parameter anymore.

Here is the test .lando.yml I was using for this:

name: my-lando-app
recipe: lemp
config:
  webroot: .
services:
  database:
    type: mysql:8.4

[AaronFeledy]

It sounds like you have data for a different database version. You probably need to lando destroy to wipe out the old data, then import it into your new version.