Laradock MySQL container exits(0) - Different lower_case_table_names settings for server ('2') and data dictionary ('0')

Laradock MySQL container exits(0) - Different lower_case_table_names settings for server ('2') and data dictionary ('0')

After updating my Docker to the latest version when I tried to bring docker up. I would receive the following error.

mysql_1                | 2020-10-02T08:43:56.795760Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /var/lib/mysql/ is case insensitive

mysql_1                | 2020-10-02T08:43:56.811892Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.

mysql_1                | 2020-10-02T08:43:59.337854Z 1 [Warning] [MY-012579] [InnoDB] fallocate(16, FALLOC_FL_PUNCH_HOLE | FALLOC_FL_KEEP_SIZE, 0, 16384) returned errno: 22

mysql_1                | 2020-10-02T08:43:59.353930Z 1 [Warning] [MY-012579] [InnoDB] fallocate(17, FALLOC_FL_PUNCH_HOLE | FALLOC_FL_KEEP_SIZE, 0, 16384) returned errno: 22

mysql_1                | 2020-10-02T08:43:59.370365Z 1 [Warning] [MY-012579] [InnoDB] fallocate(18, FALLOC_FL_PUNCH_HOLE | FALLOC_FL_KEEP_SIZE, 0, 16384) returned errno: 22

mysql_1                | 2020-10-02T08:43:59.384349Z 1 [Warning] [MY-012579] [InnoDB] fallocate(19, FALLOC_FL_PUNCH_HOLE | FALLOC_FL_KEEP_SIZE, 0, 16384) returned errno: 22

mysql_1                | 2020-10-02T08:43:59.403411Z 1 [Warning] [MY-012579] [InnoDB] fallocate(20, FALLOC_FL_PUNCH_HOLE | FALLOC_FL_KEEP_SIZE, 0, 16384) returned errno: 22

mysql_1                | 2020-10-02T08:43:59.419314Z 1 [Warning] [MY-012579] [InnoDB] fallocate(21, FALLOC_FL_PUNCH_HOLE | FALLOC_FL_KEEP_SIZE, 0, 16384) returned errno: 22

mysql_1                | 2020-10-02T08:43:59.441356Z 1 [Warning] [MY-012579] [InnoDB] fallocate(22, FALLOC_FL_PUNCH_HOLE | FALLOC_FL_KEEP_SIZE, 0, 16384) returned errno: 22

mysql_1                | 2020-10-02T08:43:59.459212Z 1 [Warning] [MY-012579] [InnoDB] fallocate(23, FALLOC_FL_PUNCH_HOLE | FALLOC_FL_KEEP_SIZE, 0, 16384) returned errno: 22

mysql_1                | 2020-10-02T08:43:59.476652Z 1 [Warning] [MY-012579] [InnoDB] fallocate(24, FALLOC_FL_PUNCH_HOLE | FALLOC_FL_KEEP_SIZE, 0, 16384) returned errno: 22

mysql_1                | 2020-10-02T08:43:59.492347Z 1 [Warning] [MY-012579] [InnoDB] fallocate(25, FALLOC_FL_PUNCH_HOLE | FALLOC_FL_KEEP_SIZE, 0, 16384) returned errno: 22

mysql_1                | 2020-10-02T08:43:59.526730Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.

mysql_1                | 2020-10-02T08:43:59.552704Z 1 [ERROR] [MY-011087] [Server] Different lower_case_table_names settings for server ('2') and data dictionary ('0').

mysql_1                | 2020-10-02T08:43:59.553395Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.

mysql_1                | 2020-10-02T08:43:59.554660Z 0 [ERROR] [MY-010119] [Server] Aborting

To fix this. Open the Docker Desktop and click the settings button at the top and uncheck this button. Apply and Save.

Uncheck this button

Now run docker-compose up nginx mysql phpmyadmin redis

Categories: Posts