List:General Discussion« Previous MessageNext Message »
From:John Daisley Date:November 12 2009 6:30pm
Subject:Re: cannot find my.cnf file
View as plain text  
should be in 

/etc/my.cnf

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/object01.pid
> 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/object01.pid
> 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!
> 
> TIA
> 
> Syd
> 
> 
> 
>       
> 

Thread
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