3

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

  • what distro are you using? It might help us to narrow it down. – Derek Downey Sep 22 '11 at 17:23
7

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)

  • 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
6

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.

3

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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