Change SQL Mode on MAMP Free

Change Your SQL Mode in MAMP Free. Easy 4 Steps for anyone.

Tweet
Share
Share
Pin

If you want to change the SQL mode that MAMP Free is running follow these easy steps to do so.

1. Quit MAMP (stop the servers)

2.Run following command in the terminal – it will open the config file inside your text editor app:
touch /Applications/MAMP/conf/my.cnf && open -t /Applications/MAMP/conf/my.cnf

3.When the file is empty, then add the following content:

[mysqld]
sql_mode=""

(When the file is not empty, then simply add the line sql_mode="" right after the line [mysqld])

4. Save the config file and close the text editor; restart MAMP and start the servers.