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.daisley@stripped]
Sent: Thursday, November 12, 2009 10:30 AM
To: Sydney Puente
Cc: mysql@stripped
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
> [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
>
>
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1
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.
