Mysql啟用記錄設定

今天終於讓MySql的記錄功能啟用，設定內容如下：
1 [mysqld]
2 datadir=/var/lib/mysql
3 socket=/var/lib/mysql/mysql.sock
4 user=mysql
5 # Default to using old password format for compatibility with mysql 3.x
6 # clients (those using the mysqlclient10 compatibility package).
7 old_passwords=1
8 default-storage-engine=INNODB
9 default-character-set = utf8
10 collation-server = utf8_general_ci
11
12 #同步記錄檔
13 #binlog-do="wunsanmessage"
14 server-id=1
15
16 #系統記錄檔
17 log-error=/var/log/mysql/mysqld-err.log
18 log-bin=/var/log/mysql/mysqlPS02DB
19 log=/var/log/mysql/mysqlPS02access
20
21 [mysqld_safe]
22 pid-file=/var/run/mysqld/mysqld.pid
23
24 #***INNODB ***
25 #skip-innodb
26
27 innob-additional-mem-pool-size=2M
28 innodb-flush-log-at-trx-commit=1
29 innodb-log-group-home-dir=/var/log/mysql
30 innodb-log-files-in-group=4
31 innodb-log-file-size=32M
32 innodb-log-buffer-size=5M
33 innodb_buffer_pool_size=512
34
35 innodb_thread_concurrency=8
以上是設定檔，除了設定檔外，還要記得/var/log/mysql這個自設的目錄是否有mysql的權限；用640或660皆可。