LinuxQuestions.org - mysql configuration file

- Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)

- - mysql configuration file (https://www.linuxquestions.org/questions/linux-newbie-8/mysql-configuration-file-937277/)

mysql configuration file

Hi all,

Installed mysql on RHEL5 server and unable to find the
config file "my.cnf"

Tried in /etc, /usr, /opt, and /var but no luck.

Where else to look for. (find command returned no results)

Code:

# find /var /opt /usr /tmp -name my.cnf

find: Filesystem loop detected; `/opt/biohub/project/.snapshot' has the same device number and inode as a directory which is 1 level higher in the filesystem hierarchy.

find: Filesystem loop detected; `/opt/biohub/.snapshot/hourly.20' has the same device number and inode as a directory which is 1 level higher in the filesystem hierarchy.

Code:

[root@box ~]# ls -ltrh /etc/ |grep my.cnf

[root@box ~]# echo $?

1

[root@box ~]# ls -ltrh /etc/ |grep cnf

[root@box ~]# echo $?

1

[root@box ~]# ls -ltrh /etc/ |grep mysql

[root@box ~]# echo $?

1

[root@box ~]#

Code:

# mysql -V

mysql  Ver 14.14 Distrib 5.5.22, for Linux (x86_64) using readline 5.1

How did you install it? If you installed from RPM then you should surely have a decent default there, but if you built it from source then that' would explain why there would be none. In that case there should be a default within the original source for you to modify.

Hi

I installed RPMs but somehow couldn't find the config file.

Code:

rpm -ivh MySQL-server-5.5.22-1.linux2.6.x86_64.rpm MySQL-client-5.5.22-1.linux2.6.x86_64.rpm



and 



rpm -ivh MySQL-devel-5.5.22-1.linux2.6.x86_64.rpm

Ah, OK those aren't distro specific ones. Any reason installing via yum wasn't your preferred option? I presume if you do a "rpm -ql MySQL-server" you'll see it in there somewhere.