search

Home  >  Q&A  >  body text

The storage location of my.cnf file on macOS

<p>I'm trying to follow this tutorial to enable remote access to MySQL. The question is, where should the <code>my.cnf</code> file be placed? I'm using Mac OS X Lion. </p>
P粉242535777P粉242535777518 days ago603

reply all(2)I'll reply

  • P粉005417748

    P粉0054177482023-08-22 12:48:01

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

    reply
    0
  • P粉950128819

    P粉9501288192023-08-22 09:59:35

    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:

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

    reply
    0
  • Cancelreply