Skip to content

Instantly share code, notes, and snippets.

@phpfui
phpfui / Reinit_MySQL_Windows.md
Last active July 19, 2021 16:25
Reinitialize MySQL in Windows

Reinitialize MySQL in Windows

MySQL has an annoying habit of lowercasing table names under Windows with the default installation.

The suggested solution for this is to set lower_case_table_names=2 under the [mysqld] section in my.ini.

This works well, but with one issue. You can not change this after you install MySQL, and this is NOT the the default under Windows on a new install, and many times installs do not you allow you to edit my.ini before the server is initialized.

Here is how to change the lower_case_table_names on an existing MySQL install under Windows: