Where is my.cnf on mac

But it did not give me the folder I wanted, I guess there are more than one. The file I put into my home folder did for me what I wanted. So its good to go. And please take note of the following as mentioned in MySQL documentation: "MySQL looks for option files in the order just described and reads any that exist.

So you can create my. All rights reserved. By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies. Location of my. But still, welcome to SO! Or should I make some kind of mysql directory there? On Mac OS Sierra, it wasn't set up already. Note that the mysql is symlinked to the package, in my case mysql Just did a clean install of MySQL 5.

There's no my. And there's no my-default. Turns out that "as of MySQL 5. I'm on High Sierra but it was installed a few versions back. But all of these my. Andru If none of them exists, create a new one. At any of the listed locations? Answered By: John Bachir. Answered By: Fusca Software. Answered By: naabster. Answered By: luis19mx. Answered By: kenorb.

Answered By: chrismealy. Answered By: Connor Leech. Answered By: Andrey. Server Fault is a question and answer site for system and network administrators. It only takes a minute to sign up. Connect and share knowledge within a single location that is structured and easy to search. I've got a Mac OS X I've tried searching the filesystem for a my.

It all runs fine, so is there something I can run against the MySQL server instance to find out where it loaded its config file from? You can find where MySQL is looking for its config files so you know where to look, or where to put one by asking the tools.

For example:. This will show the locations in which it's searching for config files in order. The server should use the same configs. The example above is from the installation from Macports; yours may be different.

It looks like MySQL runs with a default config until a my. You can create a my.