我试图按照本教程来启用远程访问MySQL。问题是,my.cnf文件应该放在哪里?我使用的是Mac OS X Lion。


当前回答

macOS sierra 10.12.6 MySQL版本:5.7.18_1 我运行locate my。cnf,路径是

/ usr / local / etc / 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.

将/usr/local/opt/mysql/support-files/my-default.cnf复制为/etc/my.cnf或/etc/mysql/my.cnf,然后重启mysql。

为我在sierra版本

复制默认配置:

/usr/local/Cellar/mysql/5.6.27/support-files / my-default.cnf

to

/usr/local/Cellar/mysql/5.6.27/my.cnf

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

我正在运行MacOS Catalina(10.15.3),并在/usr/local/etc中找到my.cnf