MySQL 数据库编码配置

5.5
安装路径下的 my.ini
5.6+
C:\ProgramData\MySQL\MySQL Server 5.7\my.ini

5.5 5.6配置

[mysql]
default-character-set=utf8

[mysqld]
character_set_server=utf8

create database eos default character set utf8;

5.7配置

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
default-storage-engine=INNODB
character-set-server=utf8
innodb_large_prefix = on
innodb_file_format = Barracuda
innodb_file_format_check = ON
innodb_file_format_max = Barracuda
innodb_file_per_table = ON
transaction-isolation = READ-COMMITTED

版权属于：wshon

本文链接：https://blog.wshon.com/2019/06/mysql.html

转载时须注明出处及本声明