Holy crud – that took a while to figure out. I was trying to work locally on a project, and kept running into the “max_allowed_packets” error when importing the database (I was using PHPMyAdmin, but this comes up elsewhere too). I knew that the default was 1M, but I had a hard time figuring out where to change this number.
It took me a while and a lot of attempts at difference solutions to find the answer – presented to me in a forum. The key is to replicate the original MySQL conf file (which MAMP apparently removes) with a larger max.
Quoted below (from “weotch”) in case the link ever rots, but here is the original:
“Ok, I think I found my answer. I copied
/Applications/MAMP/db/mysql/my.cnf (notice that I renamed it). Then I
tweaked the settings I needed to in it and restarted MAMP. Golden!”