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
H I wouldn't use that my-huge.cnf file unless that machine is a
dedicated mysql server with plenty of ram and even then I wouldn't use it
without modification.
Are you sure you have the password correct? A % under host is a synonym
for 'any host'.
Regards
John
> Guys,
> That's a great respo
Guys,
That's a great response. Thanks.
I have copied /usr/share/doc/MySQL-server-community-5.1.39/my-huge.cnfto
/etc/my.cnf and restarted.
However I can no longer log on via the command line from the database box,
I can still log via a remote client
So I presume the problem is related to the hos
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
13, 2009 3:10 AM
Subject: cannot find my.cnf file
> 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
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.
>
>
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-
10 matches
Mail list logo
