/etc/my.cnf の設定メモ

1 [mysqld]
2 log_bin=mysqld-bin
3 server_id=100
4 log-error=/var/log/mysql/mysql.err
5 log=/var/log/mysql/mysql-query.log
6 log-bin=/var/log/mysql/mysql-bin
7 default-character-set=utf8
8 datadir=/var/lib/mysql
9 socket=/var/lib/mysql/mysql.sock
10 user=mysql
11 # Default to using old password format for compatibility with mys ql 3.x
12 # clients (those using the mysqlclient10 compatibility package).
13 old_passwords=1
14
15 # Disabling symbolic-links is recommended to prevent assorted sec urity risks;
16 # to do so, uncomment this line:
17 # symbolic-links=0
18
19 [client]
20
21 [mysqld_safe]
22 log-error=/var/log/mysqld.log
23 pid-file=/var/run/mysqld/mysqld.pid
24
25 [mysql]
26 #safe-updates
27 default-character-set=utf8
28 prompt='MASTER>'
29 pager='/usr/bin/less -X'
30
31 [mysqld_safe]
32 log-error=/var/log/mysqld.log
33 pid-file=/var/run/mysqld/mysqld.pid