Which cnf file is mysql using

When you have multiple files in the appropriate paths you can see unexpected behavior when you override certain values in different files. You can however for example specify —no-defaults to use no configuration file, or add options to your command line execution, so even looking at all configuration files is no guarantee of your operating configuration. By default and on single instance MySQL servers you are most likely to find this file called my. MySQL has both instance specific and user specific locations.

For the inclusion of an instance specific file, the location is:. While you may have these default files, you may elect to start mysql with a specific configuration file as specified by —defaults-file. Peter Mortensen 29k 21 21 gold badges 97 97 silver badges bronze badges. Luke Luke This worked for me on my Server install, thanks. Make sure you are dealing with the correct version running with a Unix command of: ps -ax grep mysql.

Kershrew Kershrew 9 9 bronze badges. Just a learner Just a learner This is basically the equivalent of the top answer, for windows. I installed mysql use brew install mysql mysqld --verbose --help less And it shows:. Kernel Kernel 5 5 silver badges 8 8 bronze badges. K 7 7 silver badges 6 6 bronze badges. Sign up or log in Sign up using Google.

Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Does ES6 make JavaScript frameworks obsolete? Podcast Do polyglots have an edge when it comes to mastering programming Featured on Meta. Now live: A fully responsive profile.

Linked See more linked questions. Related The default options configuration are read in the given order from :. No error! No output, everything looks good. My server will start with this configuration. Usually your configuration options are written in your configuration file in general named my.

Therefore you can also use validate-config in this context :. This assumes that your locatedb has been updated since the my. Usually this is done daily via cron. If you need to update it manually run "updatedb" as root — ckliborn. JayRizzo 5 5 bronze badges. Updated my answer. Please try again!!!

How did you install MySQL and on what platform? Sven Sven I didn't install it, it's on a machine that's a few years old. It's on Linux mars 2. Nils Nils 7, 3 3 gold badges 29 29 silver badges 71 71 bronze badges. How are you sure that your cnf file is not being read?

Have you restarted mysqld since the change? Have you tried to create a new db and looked at its values? To install locate and updatedb to be able to run it..