安装完MySQL后,设置编码时发生问题。
我之前一次安装mysql通过以下流程:
----------------------------------------------------------
1,进入编辑my.cnf
vi /etc/my.cnf
2,在[mysqld]下边添加一下内容
character-set-server=utf8
init_connect='SET NAMES utf8'
3,重启MySQL
systemctl restart mysqld
----------------------------------------------------------
就可以将MySQL的字符集都改过来了(那个文件流的2进制的编码除外)
但这次却不行,流程如下
----------------------------------------------------------
1,进入编辑my.cnf
vi /etc/my.cnf
2,在[mysqld]下边添加以下内容
character-set-server=utf8
init_connect='SET NAMES utf8'
3,在[mysqld]
上边添加以下内容
[mysql]
default-character-set=utf8
4,重启MySQL
systemctl restart mysqld
----------------------------------------------------------
这次将MySQL的字符集都改过来了(当然,那个文件流的2进制的编码还是除外)
可能是系统或MySQL的版本原因吧(我装的都是MySQL5.7的版本)
下边是查看MySQL编码的命令行:
mysql> show variables like '%character%';
修改完成后显示结果如下:
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| 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/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)
可参考:
http://blog.csdn.net/shudaqi2010/article/details/53167063
http://www.linuxidc.com/Linux/2016-09/135288.htm