Where is my.cnf in CSWmysql5?

I installed MySQL 5.0 using pkgutil, and I want to change the my.cnf file to adjust settings. Where to find this file?

asked: 2012-02-07 by: automaciej

AirOnSkin answers:

MySQL has default search locations for the my.cnf file. When you enter the following command:
mysql --verbose --help
you see somewhere in the middle of the output (afte the option reference) these lines:

Default options are read from the following files in the given order:  
/etc/my.cnf /etc/opt/csw/my.cnf ~/.my.cnf

OpenCSW provides some example my.cnf files which can be found at: /opt/csw/share/mysql/my-*.sql
Copy and edit one of these files according to your needs.