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. Regards, Gavin Towey -----Original Message----- From: John Daisley [mailto:john.dais...@butterflysystems.co.uk] Sent: Thursday, November 12, 2009 10:30 AM To: Sydney Puente Cc: mysql@lists.mysql.com Subject: Re: cannot find my.cnf file 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 > [r...@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 > [r...@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 > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=gto...@ffn.com 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
