您可以打开一个终端并键入locate my.cnf

在Mac OS X Maverick的情况下，当MySQL通过Homebrew安装时，它位于/usr/local/opt/mysql/my.cnf

在mysql 5.6.22中，my.cnf的路径为

/usr/local/opt/mysql/my.cnf 

In my case, the file did not exist. In MySQL Workbench I went to OPTIONS FILE and found some default values. I clicked apply. It asked for permission. It then created the my.cnf file under /etc. However, it is very important to keep in mind that the first time you click "apply", you do not make any changes to the default configuration. Once the file has been created, you can make changes which will be applied when you click "apply". Otherwise you will not be shown the apply button when you make changes.

我在macOS Sierra上安装了MySql 5.7.12

支持文件位于

/usr/local/opt/mysql/support-files

只要将my-default.cnf复制到/etc/my.cnf或/etc/mysql/my.cnf，重新启动时配置就会被拾取。

在MAC OS上，一个快速的方法是:

sudo find /usr/ -type f -iname "*my.cnf*"

or

brew list mysql@5.7 |grep -i my.cnf

问候