my.cnf おれおれテンプレート

[mysqld]
# basic
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
old_passwords=1(いらないかもね)
expire_logs_days=2
server-id=[ipアドレスを使った数字がいいんじゃね?]
default-table-type=InnoDB
default-character-set=utf8
character_set_server=utf8
skip-character-set-client-handshake


# session
init_connect='SET AUTOCOMMIT=0'


# slow query log
log-slow-queries=/var/log/mysqld/slow/query.log
long_query_time=1
log-queries-not-using-indexes


# replication
master-host="マスタipアドレス"
master-user="ユーザ名"
master-password="パスワード"
master-port="ポート番号( default 3306 )"
relay-log=/var/log/mysqld/replication/relay-bin
relay-log-index=/var/log/mysqld/replication/relay-bin


[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
default-character-set=utf8

[mysqld.server]
default-character-set=utf8

解説なし!