Logging Queries on mysql with FreeBSD

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
I am trying to set up my mySQL server on FreeBSD to log every query a
user runs.  I understand I must edit the my.cnf file.  But one does not
exist for my install.  I installed mySQL from the FreeBSD packages and
for some reason, it did not create a my.cnf file in /etc or anywhere.
Where can I set it up to log every query a user runs?

Re: Logging Queries on mysql with FreeBSD

Quoted text here. Click to load it

Correct, the my.cnf file does not exist in a default installation.  You have
to create it.

The my.cnf file typically resides either in /etc or in $MYSQL_HOME (aka the
You can also specify the location of a supplementary options file when
invoking mysqld (e.g. within the mysqld_safe script) using
option --default-extra-file=<path>.

See http://dev.mysql.com/doc/refman/5.0/en/option-files.html for more
information on the location and format of the option files.

You can also enable the General Query Log using command-line arguments to
mysqld, without editing the my.cnf file; see
http://dev.mysql.com/doc/refman/5.0/en/query-log.html.  However, to enable
this by default you'd probably want to edit the mysqld_safe script that
invokes mysqld.  It's better to use the my.cnf file, so that the options
will take effect automatically when MySQL starts.

Bill K.

Site Timeline