The Mysql container cannot be started using the web app created by Docker+Lavel, Nginx, Mysql, phpmyadmin.

environment
WSL2 (Ubuntu 22.04)
Docker Nginx
Mysql
Phpmyadmin

What do you want to do

Since Mysql cannot be started, I want to find out the cause and start it.

Status

Migration failed → Mysql is not starting → I want to start Mysql (I can't do it here)

Tried

Fix .env → Reboot Mysql (cannot boot, check logs below)

Error Contents

The Mysql container log says this.

Can anyone think of a solution?

*I am very sorry that it is difficult to understand as this is my first time to ask a question.
Please let me know if you need any additional information.

2023-03-08 16:12:10 + 09:00 [Note] [Entrypoint]—Entrypoint script for MySQL Server 8.0.32-1.el8 started.
2023-03-08 16:12:10 + 09:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2023-03-08 16:12:10 + 09:00 [Note] [Entrypoint]—Entrypoint script for MySQL Server 8.0.32-1.el8 started.
'/var/lib/mysql/mysql.sock'->'/var/run/mysqld/mysqld.sock'
2023-03-08T16:12:11.083554 + 09:00 [Warning] [MY-011068] [Server] The syncax' -- skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 installed.
2023-03-08T16:12:11.104796 + 09:00 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy installed.
2023-03-08T16:12:11.104836 + 09:00 [System] [MY-010116] [Server] /usr/sbin/mysqld(mysqld8.0.32) starting as process1
2023-03-08T16:12:11.119709+09:001 [System][MY-013576][InnoDB]InnoDB initialization has started.
2023-03-08T16:12:11.428747 + 09:00 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-03-08T16:12:11.440037+09:001 [ERROR] [MY-011087] [Server] Different lower_case_table_names settings for server('0') and data dictionary('2').
2023-03-08T16:12:11.440341 + 09:00 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-03-08T16:12:11.440367 + 09:00 [ERROR] [MY-010119] [Server] Aborting
2023-03-08T16:12:11.968129 + 09:00 [System] [MY-010910] [Server] /usr/sbin/mysqld —Shutdown complete (mysqld 8.0.32) MySQL Community Server - GPL.
2023-03-08 16:12:25 + 09:00 [Note] [Entrypoint]—Entrypoint script for MySQL Server 8.0.32-1.el8 started.
2023-03-08 16:12:25 + 09:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2023-03-08 16:12:25 + 09:00 [Note] [Entrypoint]—Entrypoint script for MySQL Server 8.0.32-1.el8 started.
'/var/lib/mysql/mysql.sock'->'/var/run/mysqld/mysqld.sock'
2023-03-08T16:12:25.761092 + 09:00 [Warning] [MY-011068] [Server] The syncax' -- skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 installed.
2023-03-08T16:12:25.765075 + 09:00 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy installed.
2023-03-08T16:12:25.765118 + 09:00 [System] [MY-010116] [Server] /usr/sbin/mysqld(mysqld8.0.32) starting as process1
2023-03-08T16:12:25.772182 + 09:00 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2023-03-08T16:12:25.887047 + 09:00 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2023-03-08T16:12:25.895347 + 09:00 1 [ERROR] [MY-011087] [Server] Different lower_case_table_names settings for server('0') and data dictionary('2').
2023-03-08T16:12:25.896610 + 09:00 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2023-03-08T16:12:25.896663 + 09:00 [ERROR] [MY-010119] [Server] Aborting
2023-03-08T16:12:26.429459 + 09:00 [System] [MY-010910] [Server] /usr/sbin/mysqld —Shutdown complete (mysqld 8.0.32) MySQL Community Server - GPL.

mysql windows docker laravel

2023-03-11 20:21

1 Answers

[ERROR] [MY-011087] [Server] Different lower_case_table_names settings for server('0') and data dictionary('2').

Based on the error message, it appears that there is a discrepancy between the case sensitivity supported by the DBMS (file system) and the case sensitivity specified in mysqld.cnf.

It seems that lower_case_table_names must be specified when initializing DBMS (even if you reset the parameters after initialization), so I think it will be resolved if you initialize it.

# There is a helpful post on the main house stackoverflow

https://stackoverflow.com/questions/51803216/lower-case-table-names-settings-in-mysql-8-0-12

2023-03-12 12:09

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656