max_allowed_packet is stuck when using mamp

Question

I've created a my.cnf file and placed it according to this question. I've logged in to mysql as root and SET GLOBAL max_allowed_packet=536870912. I've restarted MAMP. I keep getting this:

mysql> show variables like 'max_allowed_packet';
+--------------------+----------+
| Variable_name      | Value    |
+--------------------+----------+
| max_allowed_packet | 16777216 |
+--------------------+----------+
1 row in set (0.00 sec)

BTW,

$ which mysql
/Applications/MAMP/Library/bin/mysql

and

$ mysql --help | grep cnf
order of preference, my.cnf, $MYSQL_TCP_PORT,
/etc/my.cnf /etc/mysql/my.cnf /Applications/MAMP/conf/my.cnf ~/.my.cnf 

and

Why won't it change? What else can I try?

Answer 1

If you have MAMP set up to administer MySQL with phpMyAdmin then you can change this via the "Variables" tab in phpMyAdmin.

This was the only method which worked for me, trying to set it any other way would cause it to reset to 16M whenever I'd restart MySQL.

Answer 2

you can use phpmyadmin SQL query(s) view - show variables like 'max_allowed_packet' set - set global max_allowed_packet=33554432

Answer 3

If you change a global system variable, the value is remembered and used for new connections until the server restarts.

Thats from MySQL docs. Therefore you should add the line max_allowed_packet=536870912 to my.cnf file under [mysqld] section (docs).