將MySql寫log檔功能關閉(MySql5.0)

1.至/etc/my.cnf
將以log=/var/log/mysql/mysql_log
調整為#log=/var/log/mysql/mysql_log
即off掉此功能

2.mysql -u [user] -p
輸入密碼後，輸入以下指令
show variables like ‘%log%’;
會顯示log功能已關閉

+---------------------------------+------------------------------+
| Variable_name                   | Value                        |
+---------------------------------+------------------------------+
...
| log                             | OFF                          |