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
