September 21st, 2012, 07:51 AM
My.cnf file missing and cannot be found at any directory
I recently removed mysql 5.1 an installed mysql 5.6 on my CENTOS 6 x86 OS. When I try to look for the my.cnf file it is missing from these directories:
mysqld --verbose --help | grep -A 1 "Default options"
/etc/my.cnf, /etc/mysql/my.cnf, and ~/.my.cnf.
Now I went to my mysql home directory which is /var/lib/mysql to find the .cnf file but all I found was auto.cnf.
Does anyone have any ideas? Could I just download a my.cnf file and place it in one of those directories?
September 22nd, 2012, 02:21 PM
It's nothing you worried about. Just create a file my.cnf and put it in /etc.
File may contains:
And how you updated mysql. Through source? Updating with yum backs up current setting, for example my.cnf becomes my.cnf.rpmsave or something like this.