You might have modified the wrong configuration file.

Run this command with your MySQL client:


On the line where it states "Default options are read from the following files in the given order:", you'll see which config files are loaded by default. And please also note that if the directive is overridden in one of the latter files, that will always override the previously set configuration for the same directive.

If you have cygwin installed, you can also grep the output to find that spot easier:


This will not work if you don't have cygwin or the "grep" program installed on your machine.

Antti / Mainio

Ok, it's fixed. I ran that command and it said lower_case_table_names was an unknown variable. Some searching led me to conclude that I had placed the lower_case_table_names line in the wrong part of my.ini. I put it under [mysqld] and the warning in Database Migration went away. I was able to do the database migration. I recommend adding this to the documentation.

Thank you!