Where find my.cnf

[Fantole]

Hello all

I have a problem with my file my.cnf

I want to modify this file to change values

But I did not find this file in etc/mysql

The folder mysql dosen't exist.

 

[GXX]

It should be here: /etc/my.cnf

If it doesn't exist, you can create it.

 

[Fantole]

Yes my file doesn't exist in etc/

But, my MySQL run Without this file.
It is normal ?

If yes.

My MySQL service take a defaut value for the option Without file ?

Thx for you help

 

[pkilam]

yes, it will use default values if the file /etc/my.cnf doesn't exists.

You should be able to find sample config. files in /usr/share/mysql

my-medium.cnf
my-large.conf
my-huge.cnf

just choose a file that fits your need and copy them as /etc/my.cnf.
You can fine tune it by modifying the contents of these files.

 

[Fantole]

I dont't have the folder mysql in /usr/share/

I search on the Web

Thank you very much for you help

 

[pchulpje_net]

I dont't have the folder mysql in /usr/share/

I search on the Web

Thank you very much for you help

if you have debian ( or maybe it works with a other distro also) you can find files using the " locate " command, just run for example : locate
my-medium.cnf and it will tell you the path of the file ( you have first let locate indexing your installation).



best regards,
Jeroenvd