微信昵称乱码mysql_微信昵称乱码及mysql编码格式设立（utf8mb4）_mysql

微信昵称乱码及mysql编码格式设置(utf8mb4)

参考文章:http://www.2cto.com/weixin/201504/386801.html

1.保证mysql版本5.5.3及以上&＃xff0c;mysql在5.5.3版本中引入新的编码格式&＃xff0c;取名为utf8mb4&＃xff0c;

如果是在mysql客户端&＃xff1a;

mysql> status;

1

mysql>status;

或者

mysql> select version();

1

mysql>selectversion();

查看mysql版本http://www.cnblogs.com/end/archive/2011/10/18/2216461.html

2.修改配置文件my.cnf

vim /etc/my.cnf

1

vim/etc/my.cnf

添加编码格式配置&＃xff1a;

[client] default-character-set &＃61; utf8mb4 [mysql] default-character-set &＃61; utf8mb4 [mysqld] character-set-client-handshake &＃61; FALSE character-set-server &＃61; utf8mb4 collation-server &＃61; utf8mb4_unicode_ci

1

[client]default-character-set&＃61;utf8mb4[mysql]default-character-set&＃61;utf8mb4[mysqld]character-set-client-handshake&＃61;FALSEcharacter-set-server&＃61;utf8mb4collation-server&＃61;utf8mb4_unicode_ci

然后重启mysql服务&＃xff0c;因oracle问题&＃xff0c;mysql在linux下没有注册成服务&＃xff0c;参考前面安装mysql的文章

查找mysql进程

ps -ef | grep mysql

1

ps-ef|grepmysql

杀进程号&＃xff0c;例如&＃xff1a;我的两个进程号是&＃xff1a;928和1085

kill -9 928 kill -9 1085

1

kill-9928kill-91085

启动mysql服务&＃xff0c;如果在root用户下&＃xff0c;不用加“sudo”

sudo /usr/local/mysql/bin/mysqld_safe --user&＃61;mysql &

1

sudo/usr/local/mysql/bin/mysqld_safe--user&＃61;mysql&

查看mysql编码

show variables like &＃39;collation_%&＃39; show variables like &＃39;character%&＃39;;

1

showvariableslike&＃39;collation_%&＃39;showvariableslike&＃39;character%&＃39;;

3.jdbc驱动需要 mysql-connector-java-5.1.35-bin.jar

mysql官网找最新jdbc驱动&＃xff0c;地址&＃xff1a;

http://dev.mysql.com/downloads/file.php?id&＃61;456317

4.jdbc驱动配置:

jdbc/:mysql/://127.0.0.1/:3306/db_mydb?autoReconnect/&＃61;true

1

jdbc/:mysql/://127.0.0.1/:3306/db_mydb?autoReconnect/&＃61;true

去掉&＃xff1a;

&useUnicode&＃61;true&characterEncoding&＃61;UTF-8

1

&useUnicode&＃61;true&characterEncoding&＃61;UTF-8

附&＃xff1a;

通过MySQL命令行修改:

mysql> set character_set_client&＃61;utf8mb4; mysql> set character_set_connection&＃61;utf8mb4; mysql> set character_set_database&＃61;utf8mb4; mysql> set character_set_results&＃61;utf8mb4; mysql> set character_set_server&＃61;utf8mb4; mysql> set character_set_system&＃61;utf8mb4; mysql> set collation_connection&＃61;utf8mb4; mysql> set collation_database&＃61;utf8mb4; mysql> set collation_server&＃61;utf8mb4;

1

mysql>setcharacter_set_client&＃61;utf8mb4;mysql>setcharacter_set_connection&＃61;utf8mb4;mysql>setcharacter_set_database&＃61;utf8mb4;mysql>setcharacter_set_results&＃61;utf8mb4;mysql>setcharacter_set_server&＃61;utf8mb4;mysql>setcharacter_set_system&＃61;utf8mb4;mysql>setcollation_connection&＃61;utf8mb4;mysql>setcollation_database&＃61;utf8mb4;mysql>setcollation_server&＃61;utf8mb4;

欢迎大家阅读《微信昵称乱码及mysql编码格式设立(utf8mb4)_mysql》,跪求各位点评&＃xff0c;by 搞代码

微信 赏一包辣条吧~

支付宝 赏一听可乐吧~