I want to set the max_allowed_packet setting for mysql (5.1.31) which is running on Solaris 10.

Unfortunately mysql does not seem to read the my.cfg. I tried to place it in /etc/mycfg, /opt/mysql/mysql/data/my.cfg and in /opt/mysql/mysql/support-files/my.cfg.

At each of these locations, the max_allowed_packet does not get set when i check with:

`select @@max_allowed_packet;`

When I start mysqld as such it does set the setting:

# su mysql
$ mysqld --defaults-file=/etc/my.cfg

This are the contents of my.cfg:

[mysqld]
max_allowed_packet = 50M

How can i make mysql read the config when i start it with the SMF tools?