27;re 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 man
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
m: 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.cn
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/mysql
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"
To:
Sent: Friday, November 13, 2009 3:10
e you a list 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
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.
>
>
