The problem is that you cannot change the value of lower_case_table_names after initializing the database. So the container realizes its running on a case-insensitive filesystem and forces lower_case_table_names=2. However, since upgrading to Docker 2.4, Docker is apparently smarter about how it mounts volumes. Up until Docker Desktop 2.4, the mysql container apparently didn't know that the underlying filesystem is not case-sensitive and set lower_case_table_names=0. The MacOS filesystem is not case-sensitive. If the file system the database is stored on is itself not case-sensitive, it will force you to use lower_case_table_names=2. The lower_case_table_names setting tells mysql how to store and compare table names.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |