我在macOS Sierra上安装了MySql 5.7.12

支持文件位于

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

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

Mac OS X Mavericks的当前MySQL包(在撰写本文时为MySQL -5.6.17-osx10.7-x86_64)在安装期间自动创建my.cnf。

它位于/usr/local/mysql-5.6.17-osx10.7-x86_64/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.

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

我在macOS Sierra上安装了MySql 5.7.12

支持文件位于

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

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

我在macOS High Sierra 10.13.3版本中使用mysql 5.7.17版本，我在这里找到了mysql配置文件。

cd /usr/local/mysql/support-files/my-default.cnf