MySQL​/MySQL5

MySQL5

CentOS6/7

Install (5.6)

yum -y install http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
yum -y install mysql mysql-devel mysql-server mysql-utilities 
mysql --version

Setting

• my.cnf

  [client]
  default-character-set = utf8mb4
  
  
  [mysql]
  default-character-set = utf8mb4
  
  
  [mysqld]
  #innodb_force_recovery = 0   # 0 -6
  #datadir=/var/lib/mysql
  #socket=/var/lib/mysql/mysql.sock
  user=mysql
  
  #
  skip-external-locking
  #key_buffer_size = 16M
  key_buffer_size = 48M
  max_allowed_packet = 64M
  innodb_log_file_size=64M
  #table_open_cache = 64
  sort_buffer_size = 512K
  net_buffer_length = 8K
  read_buffer_size = 256K
  read_rnd_buffer_size = 512K
  myisam_sort_buffer_size = 8M
  
  #
  tmp_table_size = 8M
  #
  # Disabling symbolic-links is recommended to prevent assorted security risks
  symbolic-links=0
  
  #
  #slow query
  slow_query_log
  slow_query_log-file=/var/log/mysql/slow.log
  long_query_time=5
  #
  max_connections=1024
  table_open_cache=4096
  #
  query_cache_size=48M
  query_cache_min_res_unit=2k
  #
  #log=/var/log/mysql/query.log
  #general_log_file=/var/log/mysql/query.log
  #
  #log-bin=mysql-bin
  #expire_logs_days=30
  #
  log-error=/var/log/mysql/mysqld.log
  log-warnings=1
  
  #default-character-set=utf8
  #character-set-server=utf8
  character-set-server = utf8mb4
  skip-character-set-client-handshake
  
  innodb_large_prefix=on
  
  default-storage-engine=innodb
  #collation-server = utf8_general_ci
  collation-server = utf8mb4_unicode_ci
  #
  innodb_file_format = Barracuda
  innodb_file_per_table = 1
  innodb_large_prefix
  
  
  [mysqld_safe]
  pid-file=/var/run/mysqld/mysqld.pid
  wait_timeout=604800
  
  default-character-set=utf8
  skip-character-set-client-handshake