/etc/mysql/mysql.conf.d/mysqld.cnf
bind IP
[mysqld]添加
character-set-server=utf8 collation-server=utf8_general_ci
进入msql client
mysql> show variables like '%char%';
确保字符集是utf8
mysql>SET character_set_database = 'utf8' ;
修改表格字符集
>ALTER TABLE tbl_name DEFAULT CHARACTER SET charset_name;
mysql>create database db;
mysql>grant all privileges on db.* to user@localhost identified by 'pasword';
for django mysql
#sudo apt-get install python3-dev libmysqlclient-dev
#pip install mysqlclient