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
[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
Yes I enter the password manually into the remote mysql client (actually
Oracle's SQL developer) when I login.
I thought I would restart mysql with the /etc/init.d/mysql script and go back
to the original default settings without any my.cnf present. Just to check it
was some setting in my.cnf
using to
try to log in, and the exact error message you get.
Regards
Gavin Towey
-Original Message-
From: Sydney Puente [mailto:sydneypue...@yahoo.com]
Sent: Friday, November 13, 2009 5:31 AM
To: mysql@lists.mysql.com
Subject: Re: cannot find my.cnf file
Yes I enter the password manually
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 +, 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.
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
You must copy /usr/share/doc/MySQL-server-community-5.1.39/my-somefile.cnf
file into /etc/my.cnf
If no .cnf file in /etc
MySQL use default config.
if server has 2G RAM
then use my-huge.cnf
Good luck.
- Original Message -
From: Sydney Puente sydneypue...@yahoo.com
To: