vi /etc/mysql/my.cnf
发现引用两个配置文件
!includedir /etc/mysql/conf.d
!includedir /etc/mysql/mysql.conf.d
两个文件添加编码格式
sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
在[mysqld] 的skip-external-locking下,添加character-set-server=utf8
......
[mysqld]
......
skip-external-locking
character-set-server=utf8
......
sudo vi /etc/mysql/conf.d/mysql.cnf
添加如下
[mysql]
default-character-set=utf8
最后
service mysql restart 即可
支持中文编码
设置mysql编码格式,亲测还可以用
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
如果仍有编码不是utf8的,请检查配置文件,也可使用mysql命令设置:
set character_set_client = utf8;
set character_set_server = utf8;
set character_set_connection = utf8;
set character_set_database = utf8;
set character_set_results = utf8;
set collation_connection = utf8_general_ci;
set collation_database = utf8_general_ci;
set collation_server = utf8_general_ci;