CREATE DATABASE IF NOT EXISTS yourdbname DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
打开my.cnf后,在文件内的[mysqld]下增加如下两行设置:
character_set_server=utf8
init_connect='SET NAMES utf8'
init_connect='SET NAMES utf8'
保存退出
CREATE DATABASE IF NOT EXISTS yourdbname DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
打开my.cnf后,在文件内的[mysqld]下增加如下两行设置:
转载于:https://www.cnblogs.com/merseyalma/p/7693033.html