Ubuntu下更改Mysql默认字符集 遇到问题

网上解决方法:

查看mysql现在的编码:
mysql> show variables like 'character%';
+--------------------------+----------------------------------------------+
| Variable_name | Value |
+--------------------------+----------------------------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin 1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | latin1 |
| character_sets_dir | /usr/local/mysql5.0.67/share/mysql/charsets/ |
+--------------------------+----------------------------------------------+

修改启动时的配置文件my.cnf
找到客户端配置[client] 在下面添加
default-character-set=utf8 默认字符集为utf8
在找到[mysqld] 添加
default-character-set=utf8 默认字符集为utf8
init_connect='SET NAMES utf8' (设定连接mysql数据库时使用utf8编码,以让mysql数据库为utf8运行)


修改好后,重新启动mysql

修改后Mysql无法启动报“/usr/sbin/mysqld: unknown variable 'default-character-set=utf8'”错误

解决方法:

修改[mysqld]下default-character-set=utf8为:

character_set_server=utf8

init_connect='SET NAMES utf8'也不需要配置

原文地址:https://www.cnblogs.com/asd14828/p/3017044.html