检查
show variables like '%character%';
show variables like '%collation%';
1、在[client]字段里加入default-character-set=utf8,如下:
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
default-character-set=utf8
2、在[mysqld]字段里加入character-set-server=utf8,如下:
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
character-set-server=utf8
3、在[mysql]字段里加入default-character-set=utf8,如下:
[mysql]
no-auto-rehash
default-character-set=utf8
验证
show variables like '%character%';
show variables like '%collation%';
python 3 django 使用pymysql
先要安装参考源码安装,再python3 setup.py install
配置settings:
'ENGINE': 'django.db.backends.mysql'
__init__.py:
pymysql
pymysql.install_as_MySQLdb()