The storage location of my.cnf file on macOS

Question

I'm trying to follow this tutorial to enable remote access to MySQL. The question is, where should my.cnf file be placed? I'm using MacOSXLion.

P粉005417748 · Answer

For Mac OS X Maverick, if MySQL is installed through Homebrew, its location is /usr/local/opt/mysql/my.cnf

P粉950128819 · Answer

This MySQL forum post says:

OS X provides sample configuration files at /usr/local/mysql/support-files/.

If you can't find them there, MySQL Workbench can create them for you with the following steps:

Open a connection.
Select the "Administration" tab in the left column, and then select "Options File" under "INSTANCE" in the menu.
MySQL Workbench will search for my.cnf and if not found, it will create it for you.