My.cnf for mysql


Hi, I just installed 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



my.cnf file can be present under multiple location.

You can find better explanation over here


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

Absolute path is /root/.my.cnf.


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.