linux mysql设置编码_linux下修改mysql编码

通过MySQL命令行修改:mysql> set character_set_client=utf8;Query OK, 0 rows affected (0.00 sec)mysql> set character_set_connection=utf8;Query OK, 0 rows affected (0.00 sec)mysql> set character_set_database=utf8;Query OK, 0 rows affected (0.00 sec)mysql> set character_set_results=utf8;Query OK, 0 rows affected (0.00 sec)mysql> set character_set_server=utf8;Query OK, 0 rows affected (0.00 sec)mysql> set character_set_system=utf8;Query OK, 0 rows affected (0.01 sec)mysql> set collation_connection=utf8;Query OK, 0 rows affected (0.01 sec)mysql> set collation_database=utf8;Query OK, 0 rows affected (0.01 sec)mysql> set collation_server=utf8;Query OK, 0 rows affected (0.01 sec)

查看编码：

show variables like "%char%";

启动：sudo /etc/init.d/mysql start

停止：sudo /etc/init.d/mysql stop

重启：sudo /etc/init.d/mysql restart

先前步骤：

1. 找到mysql的配置文件，拷贝到etc目录下，第一步很重要 　　把/usr/share/doc/mysql-server-5.1.52/my-large.cnf 复制到 /etc/my.cnf 　　即用命令：cp /usr/share/doc/mysql-server-5.1.52/my-large.cnf  /etc/my.cnf 2. 打开my.cnf修改编码

修改mysql编码

上面步骤中可以看出红色的部分的编码——latin1

3.1 修改mysql的配置文件——/etc/mysql/my.cnf：

a) 打开mysql配置文件：vim/etc/mysql/my.cnf

b) 在[client]下追加：default-character-set=utf8

c) 在[mysqld]下追加：character-set-server=utf8

d) 在[mysql]下追加：default-character-set=utf8

e) 保存并退出