Which my.cnf is being used

Mark B Mark B 4, 2 2 gold badges 23 23 silver badges 29 29 bronze badges. And I assume the last file listed wins? I checked each and everyone of those and they're all empty on my mac..

This doesn't give the loaded configuration. I don't think this will list files specified by! I'm trying to figure out why the!

Why would you need to call mysqld with the full path?! Show 3 more comments. For windows one simple way is to dump the output to a file if you like to analyze the content. On windows, it told me a list of locations but not the right one, that instead i manage to find with mysql workbench stackoverflow. Not sure it should matter, but you might want to use mysqld instead of mysql — nl-x. And still in Windows I experience that the my. Upvoted for mysqld --print-defaults , it gave me exactly what I wanted when I googled this question.

And how to do that on a running system without messing up anything? Then run strace with the mysql command you copied. I don't have the open How do you I know now which file is loaded? Alexandru Trandafir Catalin Alexandru Trandafir Catalin 2, 2 2 gold badges 30 30 silver badges 36 36 bronze badges. This works for MySQL 5. An alternative is to use mysqladmin variables. Ratan Sebastian 1, 14 14 silver badges 23 23 bronze badges.

Steve Steve 2 2 silver badges 2 2 bronze badges. It doesn't actually say where the cnf file is in my variables. I'm currently running MySQL 5. However, I can say that once upon a time this did work as I have seen it previously in the variables. Perhaps something changed since moving to 5. Wodin 2, 1 1 gold badge 24 24 silver badges 52 52 bronze badges. Sasha Sasha 6 6 silver badges 5 5 bronze badges. Herta Herta 1 1 silver badge 2 2 bronze badges.

Peter Mortensen 29k 21 21 gold badges 97 97 silver badges bronze badges. Confirm that my. Asked 10 years, 9 months ago. Active 9 years, 9 months ago. Viewed 13k times. Does anyone know if there is a way to confirm if any my. Improve this question. Toby Toby 1, 2 2 gold badges 12 12 silver badges 11 11 bronze badges. Why are you wondering if it is reading your my. If you put a error on the my. So it does, I was able to use that to track down my problem, cheers!

Related: MySQL my. Add a comment. Active Oldest Votes. Improve this answer. Community Bot 1. Derek Downey Derek Downey 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.. J Baron J Baron 1 1 silver badge 7 7 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?