//这样写的前提时你的mysql装在 /usr/local/mysql
mysql指的时你把解压后的mysql包改为mysql
[mysqld]
port=3306 datadir=/usr/local/mysql/data
socket=/usr/local/mysql/mysql.sock
user=mysql
max_connections=3
Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
设置忽略大小写
lower_case_table_names = 1
指定编码
character-set-server=utf8
collation-server=utf8_general_ci
开启ip绑定
bind-address = 0.0.0.0
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid