HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Where does my.cnf get stored in Linux?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
storedwherecnfgetdoeslinux

Problem

I am new to linux, and i just installed MySQL-server-5.1.59-1.glibc23.i386.rpm in my linux machine.

I wanted to know where my.cnf file gets stored..?
Will my.cnf gets created with the installation or not..?

I am using Fedora core 13

Edited: Still i am not able to find this file.
When i asked my admin, he is telling we need to copy my-large.cnf and place in /etc folder.. is it so...?

Solution

Most likely /etc/my.cnf or /etc/mysql/my.cnf. Also check /home/username/my.cnf and /home/username/.mysql/my.cnf

If no luck there you can run

find / -type f -name my.cnf


That will scan you're entire disk where non priviledged access is allowed (which is fine; it should find it, i'm assuming your distro came with it and you're able to connect or you wouldn't be asking this much; but it will tie your disk up)

Code Snippets

find / -type f -name my.cnf

Context

StackExchange Database Administrators Q#6054, answer score: 8

Revisions (0)

No revisions yet.