mysql my.cnf 配置

 1 [mysqld]
      2 collation-server = utf8_unicode_ci
      3 character-set-server = utf8
      4 datadir=/var/lib/mysql
      5 socket=/var/lib/mysql/mysql.sock
      6 log-bin=mysql-bin
      7 server-id=1
      8 user=mysql
      9 # Default to using old password format for compatibility with mysql 3.x
     10 # clients (those using the mysqlclient10 compatibility package).
     11 old_passwords=1
     12 # default-character-set=utf8
     13 init_connect='SET NAMES utf8'
     14
     15 # Disabling symbolic-links is recommended to prevent assorted security risks;
     16 # to do so, uncomment this line:
     17 # symbolic-links=0
     18
     19 [mysqld_safe]
     20 log-error=/var/log/mysqld.log
     21 pid-file=/var/run/mysqld/mysqld.pid
     22
     23 [client]
     24 default-character-set=utf8
     25
     26 [mysql]
     27 default-character-set=utf8