List:General Discussion« Previous MessageNext Message »
From:Charles Brown Date:November 13 2009 9:41am
Subject:RE: cannot find my.cnf file
View as plain text  
Please look in /etc/my.cnf 
If not found create one. Of cause, MySQL can start and run without a 'my.cnf' file that’s why you couldn't  find one.  In the absence of the my.cnf file, MySQL will use default for every parameter .


-----Original Message-----
From: walter harms [mailto:wharms@stripped] 
Sent: Friday, November 13, 2009 2:44 AM
To: Sydney Puente
Subject: Re: cannot find my.cnf file

Sydney Puente schrieb:
> 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!

Systemwide config files are always in /etc/ (see: man hier).


MySQL General Mailing List
For list archives:
To unsubscribe:

This message is intended only for the use of the Addressee and
may contain information that is PRIVILEGED and CONFIDENTIAL.

If you are not the intended recipient, you are hereby notified
that any dissemination of this communication is strictly prohibited.

If you have received this communication in error, please erase
all copies of the message and its attachments and notify us

Thank you.
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