Friday, January 09, 2009

Turning On Mysql Query Logging

Edit mysql configuration file (my.cnf, like /etc/my.cnf) and the add an entry under mysqld section

log = /var/log/mysqld-all.log

Follow the steps given below:

1. chown mysql:mysql /var/log/mysqld-all.log

2. chmod o-r /var/log/mysqld-all.log

3. /etc/init.d/mysqld restart

Now when you execute sql you should see the log :)

Friday, January 02, 2009

Happy New Year 2009

Wish you a

Created this 3D Text Image from Inkscape
(Reference Article)

This page is powered by Blogger. Isn't yours?