Mysql配置字符集失败,求助大神。问题已解决。
发表于 : 2016-04-24 1:17
目前使用是Ubutu16.04LTS系统,Mysql Ver 14.14 Distrib 5.7.11, for Linux (x86_64) ;网上的教程基本试过了,但是没用。
主要试过以下2种方法:
第一种是 sudo vi /var/lib/mysql/mysql/db.opt 并且修改为
default-character-set=utf8
default-collation=utf8_swedish_ci
第二种是 修改 /etc/mysql/my.cnf 不过这个配置文件里面是空的,于是找了找,在debain.cnf下面找到了
# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host = localhost
user = debian-sys-maint
password = ZuE3yWXT1tLzcB0k
socket = /var/run/mysqld/mysqld.sock
default-character-set=utf8
[mysql_upgrade]
host = localhost
user = debian-sys-maint
password = ZuE3yWXT1tLzcB0k
socket = /var/run/mysqld/mysqld.sock
character_set_server=utf8
init_connect='SET NAMES utf8'
于是我自己琢磨着分别在[client]加了default-character-set=utf8,在[mysql_upgrade]下加了character_set_server=utf8
init_connect='SET NAMES utf8'
结果当然是没用的。求助大神帮忙。
主要试过以下2种方法:
第一种是 sudo vi /var/lib/mysql/mysql/db.opt 并且修改为
default-character-set=utf8
default-collation=utf8_swedish_ci
第二种是 修改 /etc/mysql/my.cnf 不过这个配置文件里面是空的,于是找了找,在debain.cnf下面找到了
# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host = localhost
user = debian-sys-maint
password = ZuE3yWXT1tLzcB0k
socket = /var/run/mysqld/mysqld.sock
default-character-set=utf8
[mysql_upgrade]
host = localhost
user = debian-sys-maint
password = ZuE3yWXT1tLzcB0k
socket = /var/run/mysqld/mysqld.sock
character_set_server=utf8
init_connect='SET NAMES utf8'
于是我自己琢磨着分别在[client]加了default-character-set=utf8,在[mysql_upgrade]下加了character_set_server=utf8
init_connect='SET NAMES utf8'
结果当然是没用的。求助大神帮忙。