MySql乱码解决-优快云博客

本文链接：https://blog.youkuaiyun.com/javaproducts/article/details/6014234

安装完的MySQL的默认字符集为 latin1 ，为了要将其字符集改为用户所需要的(比如utf8)，就必须改其相关的配置文件。

查看MySQL字符设置,在MySql Command Line Client中：

mysql>show variables like 'character_set%';

按回车后会出现以下：

想要设置成utf-8：

进行以下操作：

mysql> set NAMES 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_server=utf8;
Query OK, 0 rows affected (0.00 sec)

这时再查看字符设置：
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/ |
+-----------------------------------+----------------------------------+

这样MySql就不会有中文乱码！