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 .
Charles, -----Original Message----- From: walter harms [mailto:wha...@bfs.de] Sent: Friday, November 13, 2009 2:44 AM To: Sydney Puente Cc: mysql@lists.mysql.com 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 > [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! > Systemwide config files are always in /etc/ (see: man hier). re, wh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=cbr...@bmi.com ******************************************** 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 immediately. Thank you. ********************************************
