字符集+存储引擎

• 修改字符集

  ---

  字符集和存储引擎
  修改字符集
  为了能够正常显示中文，必须把数据库的字符集设置为utf8.
  
  
  
  
  mysql> show variables like 'character%'; #查看字符集
  +--------------------------+----------------------------+
  | Variable_name | Value |
  +--------------------------+----------------------------+
  | character_set_client | utf8 |
  | character_set_connection | utf8 |
  | character_set_database | latin1 |需要修改
  | character_set_filesystem | binary |
  | character_set_results | utf8 |
  | character_set_server | latin1 |需要修改
  | character_set_system | utf8 |
  | character_sets_dir | /usr/share/mysql/charsets/ |
  +--------------------------+----------------------------+
  8 rows in set (0.01 sec)
  
  
  
  修改mysql的配置文件
  cd /etc/mysql/mysql.conf.d
  sudo cp mysql.cnf mysql.cnf.bak
  sudo vim mysql.cnf
  在[mysqld]下增加1句：
  character_set_server = utf8
  保存并重启服务
  sudo systemctl restart mysql.service #重启服务