Where does the my.cnf file belong on a MAC OS X installation of MySQL?
I find several on my system, yet I’m sure its being ignored due to not being in the right folder.
http://dev.mysql.com/doc/refman/4.1/en/option-files.html
Some say /etc/my.cnf
is there a difference between /etc/ and /private/etc
There are as I said several sample my.cnf files … … which to choose?
I have been looking for this file for several days. This mySql is installed on OSX 10.8.5 Server so yours may not be there.
Where: /usr/local/mysql-5.6.10-osx10.7-x86_64/mysql-test/suite/rpl_ndb
Notice the the top folder is ‘usr’. On my system you can not even see this much less change it. Apple is really lock things down.
I’m going to create one and put it in my ‘home’ folder, hope that works.
Just use shift-command-G and enter /usr/ to get into the folder
That does worked. But it did not give me the folder I wanted, I guess there are more than one.
The file I put into my home folder did for me what I wanted. So its good to go.
I ran this command in /usr/local/mysql on an older mac that is running 10.6.8
Server version: 5.1.53 MySQL Community Server (GPL)
[quote]databaseadmin$ sudo find . -name “*.cnf” -exec ls -al {} \;
-rw-r–r-- 1 root wheel 597 Nov 6 2010 ./mysql-test/include/default_my.cnf
-rw-r–r-- 1 root wheel 527 Nov 6 2010 ./mysql-test/include/default_mysqld.cnf
-rw-r–r-- 1 root wheel 836 Nov 6 2010 ./mysql-test/include/default_ndbd.cnf
-rw-r–r-- 1 root wheel 44 Nov 6 2010 ./mysql-test/std_data/bug15328.cnf
-rw-r–r-- 1 root wheel 260 Nov 6 2010 ./mysql-test/std_data/ndb_config_mycnf1.cnf
-rw-r–r-- 1 root wheel 641 Nov 6 2010 ./mysql-test/std_data/ndb_config_mycnf2.cnf
-rw-r–r-- 1 root wheel 312 Nov 6 2010 ./mysql-test/suite/federated/my.cnf
-rw-r–r-- 1 root wheel 492 Nov 6 2010 ./mysql-test/suite/ndb/my.cnf
-rw-r–r-- 1 root wheel 475 Nov 6 2010 ./mysql-test/suite/rpl/my.cnf
-rw-r–r-- 1 root wheel 1220 Nov 6 2010 ./mysql-test/suite/rpl/rpl_1slave_base.cnf
-rw-r–r-- 1 root wheel 306 Nov 6 2010 ./mysql-test/suite/rpl/t/rpl_circular_for_4_hosts.cnf
-rw-r–r-- 1 root wheel 132 Nov 6 2010 ./mysql-test/suite/rpl/t/rpl_current_user.cnf
-rw-r–r-- 1 root wheel 67 Nov 6 2010 ./mysql-test/suite/rpl/t/rpl_rotate_logs.cnf
-rw-r–r-- 1 root wheel 2208 Nov 6 2010 ./mysql-test/suite/rpl_ndb/my.cnf
-rw-r–r-- 1 root wheel 515 Nov 6 2010 ./mysql-test/suite/rpl_ndb/t/rpl_ndb_circular_2ch.cnf
-rw-r–r-- 1 root wheel 4781 Nov 6 2010 ./support-files/my-huge.cnf
-rw-r–r-- 1 root wheel 20151 Nov 6 2010 ./support-files/my-innodb-heavy-4G.cnf
-rw-r–r-- 1 root wheel 4755 Nov 6 2010 ./support-files/my-large.cnf
-rw-r–r-- 1 root wheel 4766 Nov 6 2010 ./support-files/my-medium.cnf
-rw-r–r-- 1 root wheel 2404 Nov 6 2010 ./support-files/my-small.cnf
[/quote]
I don’t quite know which file to use as a template nor do I know which one is the ‘current’ one. Maybe I’m just running with defaults…
I suspect I want my-innodb-heavy-4G.cnf for my Mac mini
You have to create your own my.cnf or .my.cnf file. And please take note of the following as mentioned in MySQL documentation:
"MySQL looks for option files in the order just described and reads any that exist. If an option file that you want to use does not exist, create it with a plain text editor.
If multiple instances of a given option are found, the last instance takes precedence. There is one exception: For mysqld, the first instance of the --user option is used as a security precaution, to prevent a user specified in an option file from being overridden on the command line.
Note
On Unix platforms, MySQL ignores configuration files that are world-writable. This is intentional as a security measure."