How to set lower_case_table_names in MAMP

      2 Comments on How to set lower_case_table_names in MAMP

Environment – Mac OS X
I have struggled a little to set lower_case_table_names =2 for mysql using MAMP. I have unsuccessfully tried configuring /etc/my.cnf and ~/.my.cnf. Finally (with a little help) I found that they are setting this value in MAMP/bin/startMysql.sh .Best Fake ID, Location of this file might differ because in your version of MAMP.
My config file looks like this

# /bin/sh
/Applications/MAMP/Library/bin/mysqld_safe --port=3306 --socket=/Applications/MAMP/tmp/mysql/mysql.sock --lower_case_table_names=2 --pid-file=/Applications/MAMP/tmp/mysql/mysql.pid --log-error=/Applications/MAMP/logs/mysql_error_log &

Change this file to set it to required value. Fake IDs,As you might have guessed, you can use the same approach to update other params like log-error location, or port number (port number can be changed from MAMP preferences too)

2 thoughts on “How to set lower_case_table_names in MAMP

Leave a Reply

Your email address will not be published. Required fields are marked *