Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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...?

share|improve this question
    
what distro are you using? It might help us to narrow it down. –  Derek Downey Sep 22 '11 at 17:23
add comment

3 Answers

You can actually find out where your compiled binary is instructed to read options files.

$ mysqld --help --verbose
110923 17:09:29 [Warning] Can't create test file /usr/local/mysql-5.6.2-m5-osx10.6-x86_64/data/laptop1113-2.lower-test
110923 17:09:29 [Warning] Can't create test file /usr/local/mysql-5.6.2-m5-osx10.6-x86_64/data/laptop1113-2.lower-test
110923 17:09:29 [Note] Plugin 'FEDERATED' is disabled.
mysqld  Ver 5.6.2-m5 for osx10.6 on i386 (MySQL Community Server (GPL))
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Starts the MySQL database server.

Usage: mysqld [OPTIONS]

Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf /usr/local/mysql/etc/my.cnf ~/.my.cnf 
The following groups are read: mysqld server mysqld-5.6
..

So for me it's /etc/my.cnf /etc/mysql/my.cnf /usr/local/mysql/etc/my.cnf ~/.my.cnf.

share|improve this answer
    
Great answer on compiled binaries !!! + 1 !!! –  RolandoMySQLDBA Sep 23 '11 at 21:24
add comment

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)

share|improve this answer
    
or you could run updatedb followed by locate my.cnf. You get a +1 for clarity and brevity. –  RolandoMySQLDBA Sep 22 '11 at 10:57
    
I had checked in the mentioned folders, I could not able to find there. Also I tried with the command given, it just scanned but did not give any result. Note: I had tried with root account itself. –  Phanindra Sep 22 '11 at 13:18
add comment

Check the MySQL documentation about the precedence of reading configuration files and their location.

On Unix, Linux and Mac OS X, MySQL programs read startup options from the following files, in the specified order (top items are used first).

File Name               Purpose
/etc/my.cnf             Global options
/etc/mysql/my.cnf       Global options (as of MySQL 5.1.15)
SYSCONFDIR/my.cnf       Global options (SYSCONFDIR = etc by default)
$MYSQL_HOME/my.cnf      Server-specific options
defaults-extra-file     The file specified with --defaults-extra-file=path, if any
~/.my.cnf               User-specific options

Depending on your Linux distribution your MySQL server may already be configured with a minimum configuration file and is ready to run, otherwise you may need to create a configuration file before the server can be activated. See Linux Home Server HOWTO - MySQL Server for details. You will find the predefined configurations in:

/usr/share/doc/mysql-server-?.??.??
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.