Ubuntu15.10修改Mysql5.6默认编码
系统环境
- ubuntu5.10
- mysql5.6
查看mysql配置文件
$ cd /etc/mysql
$ ls
# 存在如下目录与文件 conf.d debian.cnf debian-start my.cnf my.cnf.fallback mysql.cnf mysql.conf.d
# 查看 my.cnf文件(The MySQL database server configuration file.)发现里面有两行命令:
# !includedir /etc/mysql/conf.d/
# !includedir /etc/mysql/mysql.conf.d/
# 可知需要配置上面两个目录
修改配置文件 sudo vim/etc/mysql/conf.d/mysql.cnf
修改完成后,mysql.cnf内容如下:
[mysql]
no-auto-rehash
default-character-set=utf8
修改配置文件 sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
在[mysqld]下添加内容:
character-set-server = utf8
修改完后后内容如下:
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[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
skip-external-locking
character-set-server = utf8
...
重启mysql服务
$ sudo systemctl restart mysql ### 登录mysql并查看字符集
$ mysql -u root -p
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/ |
+--------------------------+----------------------------+
8 rows in set (0.01 sec)
到此,设置完毕。