MySQL my.cnf not found – CentOS

I installed MySQL and needed to configure it for a test replication. I needed to edit the my.cnf.
I tried to find the my.cnf on my CentOS BOX but file was not there. after looking around on net for hours, Found that my.cnf is not created automatically, and one has to create it himself.

Now Problem was where to create this my.cnf.

use following command

mysql --verbose --help

it will give you a lot of information, you need to find following text

...
...
Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf
...
...

so first mysql will look for file at /etc/my.cnf

Now how will i create the file, i have no idea what are the contents are the my.cnf

MySQL ships some sample configuration files while installation,

you can use this to locate where are the sample files.

#
locate *.cnf

and you will get something like following output.

[root@mysql-master ~]# locate *.cnf
/etc/my.cnf
/etc/pki/tls/openssl.cnf
/usr/share/doc/MySQL-server-5.5.32/my-huge.cnf
/usr/share/doc/MySQL-server-5.5.32/my-innodb-heavy-4G.cnf
/usr/share/doc/MySQL-server-5.5.32/my-large.cnf
/usr/share/doc/MySQL-server-5.5.32/my-medium.cnf
/usr/share/doc/MySQL-server-5.5.32/my-small.cnf
/usr/share/mysql/my-huge.cnf
/usr/share/mysql/my-innodb-heavy-4G.cnf
/usr/share/mysql/my-large.cnf
/usr/share/mysql/my-medium.cnf
/usr/share/mysql/my-small.cnf
[root@mysql-master ~]#

copy the file which suites your needs, i have a test VM so i will copy the least

#
cp /usr/share/mysql/my-small.cnf /etc/my.cnf
#

edit the /etc/my.cnf for your needs and restart the mysql

service mysql restart
Shutting down MySQL... SUCCESS!
Starting MySQL.. SUCCESS!

1 thought on “MySQL my.cnf not found – CentOS

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.