Skip to content

Instantly share code, notes, and snippets.

@phpfui
phpfui / Reinit_MySQL_Windows.md
Last active Jul 19, 2021
Reinitialize MySQL in Windows
View Reinit_MySQL_Windows.md

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: