My.cnf for mysql


#1

Hi, I just installed mysqltuner.pl to tune mysql.

Coming from cPanel/Apache i’m used to having the main mysql config file at /etc/.my.cnf Is there any particular place I would find this file, or how should I create a new one to use?

Thanks, jim


#2

@jimlongo

my.cnf file can be present under multiple location.

You can find better explanation over here http://stackoverflow.com/questions/2482234/how-to-know-mysql-my-cnf-location


#3

Easyengine creates my.cnf file at location ~/.my.cnf with installation run as root user.

Absolute path is /root/.my.cnf.


#4

Thanks, for consistency I’ve added /etc/my.cnf as the stackoverflow thread mentions it is one of the locations searched, and that’s where I’m used to adding performance variables on cPanel/Apache.

Thank you.


#5