List:General Discussion« Previous MessageNext Message »
From:Gavin Towey Date:November 12 2009 7:01pm
Subject:RE: cannot find my.cnf file
View as plain text  
Also note that mysql doesn't need a my.cnf file and will happily run with default values. 
It's possible that there is none and you'll have to create it.

To see where your mysqld is configured to check for the config file do:
mysql --verbose --help | grep -C3 my.cnf

This will give you a list of paths it checks in order.

Gavin Towey

-----Original Message-----
From: John Daisley [mailto:john.daisley@stripped]
Sent: Thursday, November 12, 2009 10:30 AM
To: Sydney Puente
Cc: mysql@stripped
Subject: Re: cannot find my.cnf file

should be in


or try the following at the command line

locate my.cnf

That should give you the location

On Thu, 2009-11-12 at 18:10 +0000, Sydney Puente wrote:
> Hello,
> I want to log all sql queries made against a mysql db.
> Googled and found I should add a line to my.cnf.
> However I cannot find a my.cnf file
> [root@radium init.d]# ps -ef | grep mysql
> root     13614     1  0 Sep24 ?        00:00:00 /bin/sh /usr/bin/mysqld_safe
> --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/
> mysql    13669 13614  0 Sep24 ?        00:21:40 /usr/sbin/mysqld --basedir=/
> --datadir=/var/lib/mysql --user=mysql --log-error=/var/lib/mysql/object01.err
> --pid-file=/var/lib/mysql/
> root     23050 22746  0 19:05 pts/0    00:00:00 grep mysql
> [root@radium init.d]# locate cnf
> /usr/share/doc/MySQL-server-community-5.1.39/my-huge.cnf
> /usr/share/doc/MySQL-server-community-5.1.39/my-innodb-heavy-4G.cnf
> /usr/share/doc/MySQL-server-community-5.1.39/my-large.cnf
> /usr/share/doc/MySQL-server-community-5.1.39/my-medium.cnf
> /usr/share/doc/MySQL-server-community-5.1.39/my-small.cnf
> /usr/share/man/man8/cnfsheadconf.8.gz
> /usr/share/man/man8/cnfsstat.8.gz
> /usr/share/ssl/openssl.cnf
> /usr/share/mysql/my-large.cnf
> /usr/share/mysql/my-huge.cnf
> /usr/share/mysql/my-innodb-heavy-4G.cnf
> /usr/share/mysql/my-medium.cnf
> /usr/share/mysql/my-small.cnf
> Any ideas?
> I might add i did not install mysql and I did not start it and the guy who did is in
> holiday!
> Syd

MySQL General Mailing List
For list archives:
To unsubscribe:

The information contained in this transmission may contain privileged and confidential
information. It is intended only for the use of the person(s) named above. If you are not
the intended recipient, you are hereby notified that any review, dissemination,
distribution or duplication of this communication is strictly prohibited. If you are not
the intended recipient, please contact the sender by reply email and destroy all copies of
the original message.
cannot find my.cnf fileSydney Puente12 Nov
  • Re: cannot find my.cnf fileJohn Daisley12 Nov
    • RE: cannot find my.cnf fileGavin Towey12 Nov
  • Re: cannot find my.cnf fileκΉ€μˆ˜μ˜13 Nov
  • Re: cannot find my.cnf filewalter harms13 Nov
    • RE: cannot find my.cnf fileCharles Brown13 Nov
Re: cannot find my.cnf fileSydney Puente13 Nov
  • RE: cannot find my.cnf fileGavin Towey13 Nov