Location of my cnf file on macOS

Question

I m trying to follow along this tutorial to enable remote access to MySQL  The problem is  where should my cnf file be located  I m using Mac OS X Lion

User · Answer

After the 5 7 18 version of MySQL  it does not provide the default configuration file in support-files directory  So you can create my cnf file manually in the location where MySQL will read  like  etc mysql my cnf  and add the configuration you want to add in the file

User · Answer

This thread on the MySQL forum says      By default  the OS X installation does not use a my cnf  and MySQL just uses the default values  To set up your own my cnf  you could just create a file straight in  etc     OS X provides example configuration files at  usr local mysql support-files    And if you can t find them there  MySQLWorkbench can create them for you by    Opening a connection Selecting the  Options File  under  INSTANCE  in the menu  MySQLWorkbench will search for my cnf and if it can t find it  it ll create it for you

User · Answer

In case of Mac OS X Maverick when MySQL is installed via Homebrew it s located at  usr local opt mysql my cnf

User · Answer

I don t know which version of MySQL you re using  but here are possible locations of the my cnf file for version 5 5  taken from here  on Mac OS X     etc my cnf  etc mysql my cnf SYSCONFDIR my cnf  MYSQL HOME my cnf defaults-extra-file  the file specified with --defaults-extra-file path  if any     my cnf

User · Answer

READ THE DOCS  The MySQL Documents for which version you are using will help  It is usually described as a Options File or MySQL Config File  The docs have the location of these files in the documentation  As well as other VITAL information like the location  amp  small examples of what the config file must look like  MySQL Version 8 MySQL Version 5 7 MySQL Version 5 6 MySQL Version 5 5 MySQL Version 5 6 Japanese Important Notes   On Unix platforms  MySQL ignores configuration files that are world-writable  This is intentional as a security measure   In other words  if you have the wrong permissions set on your config file the will NOT load  Example of initial setup permission of one of the config files  RIZZOMBP  ls -lah  etc my cnf -rw-r--r--  1 myusername  wheel     0B Feb 25 20 40  etc my cnf  Note   It is possible to use  include directives in option files to include other option files and  includedir to search specific directories for option files         MySQL makes no guarantee about the order in which option files in the directory will be read    Any files to be found and included using the  includedir directive on Unix operating systems must have file names ending in  cnf  On Windows  this directive checks for files with the  ini or  cnf extension   Examples of how to find your location of your config or log files ect   SQL This will not show you the config file but will help you locate your installation files folders  MySQL Version 5 7  amp  8  SELECT   FROM PERFORMANCE SCHEMA GLOBAL VARIABLES WHERE VARIABLE VALUE LIKE          MySQL Version  lt   5 6 SELECT   FROM INFORMATION SCHEMA GLOBAL VARIABLES WHERE VARIABLE VALUE LIKE          SHELL Terminal RIZZOMBP  mysql --help   grep  quot Default options quot  -A 1  Default options are read from the following files in the given order   etc my cnf  etc mysql my cnf  usr local mysql etc my cnf    my cnf  Above Command Credit To  Erwin Mayer from ServerFault RIZZOMBP  mysqld --verbose --help   grep   my cnf  -B 1  Default options are read from the following files in the given order   etc my cnf  etc mysql my cnf  usr local mysql etc my cnf    my cnf  OR RIZZOMBP  ps aux   grep -i mysqld   grep -v  USER   mysql 106 0 4 2 5 4232336 422112    Ss 7 01PM 0 57 12  usr local mysql bin mysqld --user  mysql --basedir  usr local mysql --datadir  usr local mysql data --plugin-dir  usr local mysql lib plugin --log-error  usr local mysql data mysqld local err --pid-file  usr local mysql data mysqld local pid --keyring-file-data  usr local mysql keyring keyring --early-plugin-load keyring file keyring file so  Sample File Should you need a detailed Reference Sample my cnf   https   gist github com search utf8  E2 9C 93 amp q my cnf mysql amp ref searchresults https   www linode com community questions 5749 mysql-sample-config-files https   www fromdual com mysql-configuration-file-sample   No affiliation association to the URL s  My System  RIZZOMBP  sw vers ProductName     Mac OS X ProductVersion  10 14 3 BuildVersion    18D109  RIZZOMBP  mysql -V mysql  Ver 8 0 15 for macos10 14 on x86 64  MySQL Community Server - GPL   RIZZOMBP  mysqld -V  usr local mysql-8 0 15-macos10 14-x86 64 bin mysqld  Ver 8 0 15 for macos10 14 on x86 64  MySQL Community Server - GPL

User · Answer

I m running MacOS Mojave  10 14 6  and to get MySQL to recognize my config file  I had to place it in   usr local mysql-5 7 26-macos10 14-x86 64 etc my cnf  Also I have a symbolic link pointing to it from   usr local  mysql etc my cnf     I was trying to turn off sql mode only full group by and setting that option in the config file was the only way I could get the setting to persist across sessions  The contents of the config file are    mysqld  sql mode NO ENGINE SUBSTITUTION   I m using the native install of MySQL  not the Homebrew set up

User · Answer

For me in sierra version  copy the default configuration at       usr local Cellar mysql 5 6 27 support-files my-default cnf   to      usr local Cellar mysql 5 6 27 my cnf

User · Answer

it should be usually under  usr local etc on mac if you do not find it you can create one

User · Answer

For MAMP 3 5 Mac El Capitan  create a separate empty config file and write your additional settings for mysql  sudo vim  Applications MAMP Library my cnf   And Add like this    mysqld  max allowed packet   256M

User · Answer

The current MySQL package for Mac OS X Mavericks  mysql-5 6 17-osx10 7-x86 64 at the time of this writing  automatically creates a my cnf during installation    It is located at  usr local mysql-5 6 17-osx10 7-x86 64 my cnf Adapt your path according to your version

User · Answer

Open Terminal and use below command   sudo find   -name my cnf

User · Answer

private etc my cnf for Catalina

User · Answer

I am using mysql version 5 7 17 in macOS High Sierra version 10 13 3 and I have found the mysql config file here    cd  usr local mysql support-files my-default cnf

User · Answer

For Mac   what worked for me is creating a  my cnf file in my   path  Hope this helps

User · Answer

I m running MacOS Catalina 10 15 3  and find my cnf in  usr local etc

User · Answer

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

User · Answer

Copy  usr local opt mysql support-files my-default cnf as  etc my cnf or  etc mysql my cnf and then restart mysql

User · Answer

In mysql 5 6 22  which I installed it from Homebrew  the path of my cnf is    usr local opt mysql my cnf

User · Answer

For MySQL 5 7 on Mac OS X El Capitan   usr local mysql etc my cnf  Copy default conf from  usr local mysql support-files my-default cnf

User · Answer

rDefault options are read from the following files in the given order   etc my cnf  etc mysql my cnf  usr local mysql etc my cnf    my cnf

User · Answer

macOs sierra 10 12 6 mysql version   5 7 18 1 I run locate my cnf and the path is       usr local etc my cnf   hope it help

User · Answer

So none of these things worked for me   I am using the current dmg install of mysql community server   ps shows that all of the most critical parameters normally in my cnf are passed on the command line  and I couldn t figure out where that was coming from   After doing a full text search of my box I found it in    Library LaunchDaemons com oracle oss mysql mysqld plist  So you can either change them there  or take them out so it will actually respect the ones you have in your my cnf wherever you decided to put it   Enjoy   Example of the file info found in that file    lt  xml version  1 0  encoding  UTF-8   gt   lt  DOCTYPE plist PUBLIC  -  Apple Computer  DTD PLIST 1 0  EN   http   www apple com DTDs PropertyList-1 0 dtd  gt   lt plist version  1 0  gt   lt dict gt       lt key gt Label lt  key gt               lt string gt com oracle oss mysql mysqld lt  string gt       lt key gt ProcessType lt  key gt         lt string gt Interactive lt  string gt       lt key gt Disabled lt  key gt            lt false  gt       lt key gt RunAtLoad lt  key gt           lt true  gt       lt key gt KeepAlive lt  key gt           lt true  gt       lt key gt SessionCreate lt  key gt       lt true  gt       lt key gt LaunchOnlyOnce lt  key gt      lt false  gt       lt key gt UserName lt  key gt            lt string gt  mysql lt  string gt       lt key gt GroupName lt  key gt           lt string gt  mysql lt  string gt       lt key gt ExitTimeOut lt  key gt         lt integer gt 600 lt  integer gt       lt key gt Program lt  key gt             lt string gt  usr local mysql bin mysqld lt  string gt       lt key gt ProgramArguments lt  key gt           lt array gt               lt string gt  usr local mysql bin mysqld lt  string gt               lt string gt --user  mysql lt  string gt               lt string gt --basedir  usr local mysql lt  string gt               lt string gt --datadir  usr local mysql data lt  string gt               lt string gt --plugin-dir  usr local mysql lib plugin lt  string gt               lt string gt --log-error  usr local mysql data mysqld local err lt  string gt               lt string gt --pid-file  usr local mysql data mysqld local pid lt  string gt                lt string gt --keyring-file-data  usr local mysql keyring keyring lt  string gt                lt string gt --early-plugin-load keyring file keyring file so lt  string gt            lt  array gt       lt key gt WorkingDirectory lt  key gt    lt string gt  usr local mysql lt  string gt   lt  dict gt   lt  plist gt

User · Answer

I checked in macOS Sierra  the homebrew installed MySql 5 7 12  The support files are located at    usr local opt mysql support-files   Just copy my-default cnf as  etc my cnf or  etc mysql my cnf and the configuration will be picked up on restart

User · Answer

You can create your file under any directory you want  After creation  you can  tell  the path to mysql config

User · Answer

In general  on Unix and Unix-like systems  MySQL MariaDB programs read config startup files in the following locations  in the specified order      etc my cnf -   Global  etc mysql my cnf - Global SYSCONFDIR my cnf - Global     SYSCONFDIR represents the directory specified with the SYSCONFDIR option to CMake when MySQL was built  By default  this is the etc directory located under the compiled-in installation directory    MYSQL HOME my cnf -    Server-specific  server only      MYSQL HOME is an environment variable containing the path to the directory in which the server-specific my cnf file resides  If MYSQL HOME is not set and you start the server using the mysqld safe program  mysqld safe sets it to BASEDIR  the MySQL base installation directory   file specified with --defaults-extra-file path if any    my cnf - User-specific    mylogin cnf - User-specific  clients only    Source  Using Option Files      Note  On Unix platforms  MySQL ignores configuration files that are world-writable  This is intentional as a security measure      Additionally on Mac there is a simple way to check it    Run  sudo fs usage   grep my cnf  This will report any filesystem activity in real-time related to that file  In another Terminal  restart your MySQL MariaDB  e g   brew services restart mysql   or   brew services restart mariadb  On terminal with fs usage  the proper location should be shown  e g   15 52 22  access             usr local Cellar mariadb 10 1 14 my cnf                                         0 000002   sh             So if the file doesn t exist  create one

User · Answer

If you are using macOS Sierra and the file doesn t exists   run   mysql --help or mysql --help   grep my cnf   to see the possible locations and loading reading sequence of my cnf for mysql then create my cnf file in one of the suggested directories then add the following line    mysqld  sql mode   STRICT TRANS TABLES NO ZERO IN DATE NO ZERO DATE ERROR FOR DIVISION BY ZERO NO AUTO CREATE USER NO ENGINE SUBSTITUTION  You can sudo touch   preferred-path  my cnf then edit the file to add sql mode by   sudo nano   preferred-path  my cnf   Then restart mysql  voilaah you are good to go  happy coding

User · Answer

For mysql 8 0 19  I finally found the my cnf here   usr local opt mysql  bottle etc I copied it to   usr local opt mysql  and modified it  Then I restart the mysql service  it works

User · Answer

You can check the file    usr local bin mysql server and see from where my conf is being read from    Usually it is from  etc my cnf or   my cnf or    my cnf

User · Answer

macOS High Sierra version 10 13 6  mysql  Ver 14 14 Distrib 5 7 22  for osx10 13  x86 64  using  EditLine wrapper Copyright  c  2000  2018  Oracle and or its affiliates  All rights reserved  Default options are read from the following files in the given order    etc my cnf   etc mysql my cnf   usr local etc my cnf     my cnf

User · Answer

You can open a terminal and type locate my cnf

[mysql] Location of my.cnf file on macOS

Examples related to mysql

Examples related to database

Examples related to macos