MySQL Bugs: #75045: my.cnf is missing after fresh installation

Bug #75045	my.cnf is missing after fresh installation
Submitted:	28 Nov 2014 16:53	Modified:	4 Dec 2014 10:48
Reporter:	Monika Malik	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S3 (Non-critical)
Version:	5.1	OS:	Linux
Assigned to:		CPU Architecture:	Any

Description:
I have uninstalled mysql on linux box, and removed my.cnf file as well before reinstalling it again, after installing it again from yum install mysql mysql-server -y, There is no my.cnf file in any of the default folders(/etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf).

I also tried find command but no my.cnf or my.ini file in linux box.

Please help.

How to repeat:
I have uninstalled mysql on linux box, and removed my.cnf file as well before reinstalling it again, after installing it again from yum install mysql mysql-server -y, There is no my.cnf file in any of the default folders(/etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf).

I also tried find command but no my.cnf or my.ini file in linux box.

Please help.

Suggested fix:
copying my.cnf manually.

Hello Monika,

Thank you for the report.
I'm not seeing this issue with official rpm builds:

// Downloaded package from dev.mysql.com/downloads/mysql/5.1.html#downloads

[umshastr@localhost]/export/umesh/setups: tar -xvf MySQL-community-5.1.73-1.rhel5.x86_64.rpm-bundle.tar
MySQL-community-debuginfo-5.1.73-1.rhel5.x86_64.rpm
MySQL-embedded-community-5.1.73-1.rhel5.x86_64.rpm
MySQL-client-community-5.1.73-1.rhel5.x86_64.rpm
MySQL-shared-compat-5.1.73-1.rhel5.x86_64.rpm
MySQL-server-community-5.1.73-1.rhel5.x86_64.rpm
MySQL-devel-community-5.1.73-1.rhel5.x86_64.rpm
MySQL-shared-community-5.1.73-1.rhel5.x86_64.rpm
MySQL-test-community-5.1.73-1.rhel5.x86_64.rpm
[umshastr@localhost]/export/umesh/setups: ls -l *.rpm
-rw-r--r-- 1 umshastr common  7469096 Nov  8  2013 MySQL-client-community-5.1.73-1.rhel5.x86_64.rpm
-rw-r--r-- 1 umshastr common 67013961 Nov  8  2013 MySQL-community-debuginfo-5.1.73-1.rhel5.x86_64.rpm
-rw-r--r-- 1 umshastr common 11998870 Nov  8  2013 MySQL-devel-community-5.1.73-1.rhel5.x86_64.rpm
-rw-r--r-- 1 umshastr common 36118553 Nov  8  2013 MySQL-embedded-community-5.1.73-1.rhel5.x86_64.rpm
-rw-r--r-- 1 umshastr common 20823203 Nov  8  2013 MySQL-server-community-5.1.73-1.rhel5.x86_64.rpm
-rw-r--r-- 1 umshastr common  1894921 Nov  8  2013 MySQL-shared-community-5.1.73-1.rhel5.x86_64.rpm
-rw-r--r-- 1 umshastr common  3236785 Nov  8  2013 MySQL-shared-compat-5.1.73-1.rhel5.x86_64.rpm
-rw-r--r-- 1 umshastr common 15324901 Nov  8  2013 MySQL-test-community-5.1.73-1.rhel5.x86_64.rpm
[umshastr@localhost]/export/umesh/setups: rpm -qlp MySQL-server-community-5.1.73-1.rhel5.x86_64.rpm|grep cnf
/etc/my.cnf
/usr/share/doc/MySQL-server-community-5.1.73/my-huge.cnf
/usr/share/doc/MySQL-server-community-5.1.73/my-innodb-heavy-4G.cnf
/usr/share/doc/MySQL-server-community-5.1.73/my-large.cnf
/usr/share/doc/MySQL-server-community-5.1.73/my-medium.cnf
/usr/share/doc/MySQL-server-community-5.1.73/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

Could you please confirm which exact yum repository you are trying, OS, MySQL version etc details? 

Alternatively, you can try official builds or use sample files supplied with the rpm's which should be in /usr/share/mysql/*cnf, see http://dev.mysql.com/doc/refman/5.1/en/linux-installation-rpm.html

Also, manual page on how to obtain official yum details etc here
http://dev.mysql.com/downloads/repo/yum/

Thanks,
Umesh

version_comment            | Source distribution                       
version_compile_machine    | x86_64                                                      version_compile_os         | redhat-linux-gnu 

CentOS release 6.5 (Final)

Linux version 2.6.32-431.23.3.el6.x86_64 (mockbuild@c6b8.bsys.dev.centos.org) (gcc version 4.4.7 20120313 (Red Hat 4.4.7-4) (GCC) ) #1 SMP Thu Jul 31 17:20:51 UTC 2014

and my sql is Server version: 5.1.73 Source distribution

Thank you for the feedback.
After going through provided details I see you are using Source Distribution and in that case you have to manually copy/create my.cnf.
Alternatively, you can use official rpm's which takes care of it.

Thanks,
Umesh

Can I get a sample my.cnf file, as I am not able to find it on web.