Hi Sachin,
What version of MySQL are you running? I believe --log-output was only
added in 5.1 which is why a 5.0 server would fail to start with this
option set. I think the relevant option should also be "log-output" in
my.cnf / my.ini (e.g. log-output = FILE, TABLE.)
It looks like 5.1 g
Alrite guys.
I added log=/tmp/logfile in /etc/my.cnf and removed "log = FILE,
TABLE". Now it is logging each query.
Thanks for the support.
Sachin
On Mon, Oct 6, 2008 at 3:13 PM, Sachin Gaikwad <[EMAIL PROTECTED]> wrote:
> More on this:
>
> I set following in /etc/my.cnf:
>
> log = FILE, TABLE
>
More on this:
I set following in /etc/my.cnf:
log = FILE, TABLE
after this I am not able to start my mysqld, it fails with timeout
error message "Timeout error occurred trying to start MySQL Daemon."
Thanks,
Sachin
On Mon, Oct 6, 2008 at 3:01 PM, Sachin Gaikwad <[EMAIL PROTECTED]> wrote:
> Tha
Thanks a bunch for the quick reply.
I will surely write a C program to read this logfile of general queries.
But before that I am not able to find this logfile for general queries.
I started my server like this:
$/etc/init.d/mysqld start --log=logfile --log-output=/tmp
Meaning log file will be i
This problem is Chapter 16.6 of The MYSQL Cookbook, (second edition)
that has made my(sql) life much easier. You might want to look around
at http://artfulsoftware.com/ which has lots of examples and a great
e-book resource.
Both of these are fantastic resources for me, and they are probably my
m
Hi Sachin,
MySQL is capable of logging all queries to a log file, see
http://dev.mysql.com/doc/refman/5.0/en/query-log.html. This includes
connections, disconnections and executed SQL statements - no coding needed!
If you want this information imported into a database table, a couple of
hou
Check the manual for the GRANT command. It holds the secret that you are
searching for. :) You can use it to grant specific rights to databases or
tables within databases.
Once you have granted rights for a user, then use
mysql -u username -p
the -p is only necessary if the user you are trying
