MySQL 8.4 fails to start because of mysql_native_password

[darrylhein]

My initial guess is that the same thing needs to be done that was done on Drupal's recipe: https://github.com/lando/drupal/pull/159/files

I'm happy to make an attempt at a fix, however, I don't have any experience with Lando recipes.

I believe these are the related logs:

mysql 22:11:31.31 INFO  ==> Starting mysql in background
2025-12-02T22:11:31.315292Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2025-12-02T22:11:31.446950Z 0 [System] [MY-010116] [Server] /opt/bitnami/mysql/bin/mysqld (mysqld 8.4.5) starting as process 101
2025-12-02T22:11:31.450684Z 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-12-02T22:11:31.451455Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-12-02T22:11:31.542229Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
mysqld: Table 'mysql.plugin' doesn't exist
2025-12-02T22:11:31.584057Z 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure.
2025-12-02T22:11:31.584124Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2025-12-02T22:11:31.584179Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2025-12-02T22:11:31.584228Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2025-12-02T22:11:31.584293Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2025-12-02T22:11:31.584330Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2025-12-02T22:11:31.584369Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2025-12-02T22:11:31.584420Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2025-12-02T22:11:31.597304Z 0 [Warning] [MY-010015] [Server] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2025-12-02T22:11:31.655161Z 0 [Warning] [MY-010015] [Server] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2025-12-02T22:11:31.658232Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2025-12-02T22:11:31.658248Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2025-12-02T22:11:31.660583Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2025-12-02T22:11:31.660652Z 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001146 - Table 'mysql.component' doesn't exist
2025-12-02T22:11:31.660665Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-003543 - The mysql.component table is missing or has an incorrect definition.
2025-12-02T22:11:31.660699Z 0 [ERROR] [MY-000067] [Server] unknown variable 'default_authentication_plugin=mysql_native_password'.
2025-12-02T22:11:31.660943Z 0 [ERROR] [MY-010119] [Server] Aborting
2025-12-02T22:11:33.123362Z 0 [System] [MY-010910] [Server] /opt/bitnami/mysql/bin/mysqld: Shutdown complete (mysqld 8.4.5)  Source distribution.
2025-12-02T22:11:33.123374Z 0 [System] [MY-015016] [Server] MySQL Server - end.