解决数据Mysql中中文乱码的问题 修改mysql编码方式

解决数据Mysql中中文乱码的问题 修改mysql编码方式

安装mysql后启动服务

sudo apt-get install mysql mysql-server
sudo service mysql start

进入mysql shell界面查看字符编码方式

mysql -u root -p

mysql> show variables like "char%"
    -> ;
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | latin1                     |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | latin1                     |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)

将latin1修改为utf8

1. 首先找到mysql安装位置中的my.cnf文件，默认在etc/mysql/ my.cnf。

2. 在shell中编辑配置文件

   sudo vim /etc/mysqlmy.cnf
   

3. 在【mysql】中添加character_set_server=utf8

   [mysqld]
   #
   # * Basic Settings
   #
   user            = mysql
   pid-file        = /var/run/mysqld/mysqld.pid
   socket          = /var/run/mysqld/mysqld.sock
   port            = 3306
   basedir         = /usr
   datadir         = /var/lib/mysql
   tmpdir          = /tmp
   lc-messages-dir = /usr/share/mysql
   character_set_server=utf8        //添加位置
   skip-external-locking
   
   

4. 重启服务
   sudo service mysql restart

5. 登录mysql查看编码方式

   mysql> show variables like "char%"
       -> ;
   +--------------------------+----------------------------+
   | 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)