通过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) 保存并退出 |
|