Testcontainers 1.21.3 version is incompatible with MySQL version 9.3.0 & 9.4.0

[gulsaherdil]

During jooq-codegen, testcontainers is using an incompatible variable innodb_log_file_size=5M with latest MySQL versions (9.3.0 & 9.4.0). Please see the MySQL container log:

2025-08-28 14:44:37 2025-08-28 11:44:37+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 9.3.0-1.el9 started.
2025-08-28 14:44:37 2025-08-28 11:44:37+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2025-08-28 14:44:37 2025-08-28 11:44:37+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 9.3.0-1.el9 started.
2025-08-28 14:44:37 2025-08-28 11:44:37+00:00 [Note] [Entrypoint]: Initializing database files
2025-08-28 14:44:37 2025-08-28T11:44:37.996030Z 0 [System] [MY-015017] [Server] MySQL Server Initialization - start.
2025-08-28 14:44:37 2025-08-28T11:44:37.996963Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 9.3.0) initializing of server in progress as process 80
2025-08-28 14:44:38 2025-08-28T11:44:38.002312Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2025-08-28 14:44:38 2025-08-28T11:44:38.112286Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2025-08-28 14:44:38 2025-08-28T11:44:38.855166Z 0 [ERROR] [MY-000067] [Server] unknown variable 'innodb_log_file_size=5M'.
2025-08-28 14:44:38 2025-08-28T11:44:38.855485Z 0 [ERROR] [MY-013236] [Server] The designated data directory /var/lib/mysql/ is unusable. You can remove all files that the server added to it.
2025-08-28 14:44:38 2025-08-28T11:44:38.855496Z 0 [ERROR] [MY-010119] [Server] Aborting
2025-08-28 14:44:40 2025-08-28T11:44:40.106724Z 0 [System] [MY-015018] [Server] MySQL Server Initialization - end.

Please see the bug report in testcontainers repo: testcontainers/testcontainers-java#10184
Please see the fix PR: testcontainers/testcontainers-java#10185

There is no such release for testcontainers after the above fix. We are currently fixing the issue by downgrading the MySQL version to the 9.2.0.