To enable this for the current user follow the below steps
-- create or edit the existing cnf file
vim ~/.my.cnf
-- add the below variable to the file
[server]
log=/tmp/mysql_query.log
-- restart mysql
sudo /Library/StartupItems/MySQLCOM/MySQLCOM stop
sudo /Library/StartupItems/MySQLCOM/MySQLCOM start
To enable the general query log for all users add the "variable" to /etc/my.cnf instead.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment