CentOS下安裝MySQL後中文亂碼解決方案

來源:互聯網
上載者:User

CentOS下安裝MySQL後中文亂碼解決方案

最近在CentOS下安裝MySQL程式之後,匯入資料發現有中文異常,將解決辦法整理出來以便日後參考:

步驟如下:

第一、安裝mysql之後預設的字元編碼為latin1

登入mysql之後可以通過 show variables like '%char%'查看,顯示如下

+----------------------+---------------------
| Variable_name | Value
+-----------------------+---------------------
| character_set_client | latin1
| character_set_connection | latin1
| character_set_database | latin1
| character_set_filesystem | binary
| character_set_results | latin1
| character_set_server | latin1
| character_set_system | utf8
| character_sets_dir | /usr/share/mysql/charsets/
+---------------------+----------------------

第二、進入/usr/share/mysql目錄之後,拷貝my-medium.cnf 到/etc下

[root@bkjia mysql]# cp my-medium.cnf /etc/my.cf

編輯my.cf

[root@bkjia mysql]# vim my.cf

在最後添加:

[client]
default-character-set=utf8
[mysqld_safe]
default-character-set=utf8
[mysqld]
default-character-set=utf8
[mysql]
default-character-set=utf8

儲存退出。

第三、重啟mysql服務

[root@bkjia mysql]# /etc/init.d/mysql restart

第四、登入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    | utf8                      |
| character_set_system    | utf8                      |
| character_sets_dir      | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+

OK 解決完畢!!

--------------------------------------分割線 --------------------------------------

MySQL5.7.3.0安裝配置圖解教程

Ubuntu 14.04下安裝MySQL

《MySQL權威指南(原書第2版)》清晰中文掃描版 PDF

Ubuntu 14.04 LTS 安裝 LNMP Nginx\PHP5 (PHP-FPM)\MySQL

Ubuntu 14.04下搭建MySQL主從伺服器

Ubuntu 12.04 LTS 構建高可用分布式 MySQL 叢集

Ubuntu 12.04下原始碼安裝MySQL5.6以及Python-MySQLdb

MySQL-5.5.38通用二進位安裝

--------------------------------------分割線 --------------------------------------

本文永久更新連結地址:

相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.