Same task as before, different database. I have been doing some development over the last few days with Rails and MySQL. To cut a long story short I wanted to have a look at what queries were being sent to the database. This post describes one way of turning on logging for MySQL. I did all of this on Mac OS X so your mileage may vary.

1. Create the log file

   
   > su
   > cd /var/log
   > touch mysqld.log
   > chown mysql mysqld.log
   

2. Edit /etc/my.cnf

   
   [mysqld]
   log = /var/log/mysqld.log
   
   

3. Restart the database

If you installed the MySQL Startup Item then you can restart the server simply by running:

sudo /Library/StartupItems/MySQLCOM/MySQLCOM restart

Job done!