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
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.