电脑疯子技术论坛|电脑极客社区ubuntu下mysql修改字符集latin1为utf-8查看数据库字符集状态:查看结果：上面的字符集有一个是latin1，要修改为utf-8.解决方式：到服务器/etc/mysql/mysql.conf.d找到mysqld.cnf在[mysqld] 下新增 ...

ubuntu下mysql修改字符集latin1为utf-8

2671 0


	查看数据库字符集状态: show VARIABLES like '%char%' 复制代码查看结果： character_set_client utf8 character_set_connection utf8 character_set_database utf8 character_set_filesystem binary character_set_results utf8 character_set_server latin1 character_set_system utf8 character_sets_dir /usr/share/mysql/charsets/ 复制代码上面的字符集有一个是latin1，要修改为utf-8. 解决方式：到服务器/etc/mysql/mysql.conf.d找到mysqld.cnf 在[mysqld] 下新增 character_set_server=utf8 #增加这一行，指定字符集复制代码重启数据库: sudo service mysql restart 复制代码再次查看字符集： character_set_client utf8 character_set_connection utf8 character_set_database utf8 character_set_filesystem binary character_set_results utf8 character_set_server utf8 character_set_system utf8 character_sets_dir /usr/share/mysql/charsets/ 复制代码