linux[ubuntu]下mysql字符集设置

1.安装mysql
$ sudo apt-get install mysql-server

2.字符集设置
$ sudo vim /etc/mysql/my.cnf

追加如下内容

[client] 
default-character-set=utf8 #增加这一行,指定
socket=/var/run/mysqld/mysqld.sock 

[mysqld] 
character_set_server=utf8 #增加这一行,指定字符集
pid-file=/var/run/mysqld/mysqld.pid

3.验证

$ mysql -u root -p
mysql> SHOW VARIABLES LIKE ‘character_set_%’;

+--------------------------+----------------------------+
| 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/ |
+--------------------------+----------------------------+
上一篇:IntelliJ IDEA的激活


下一篇:ubuntu-ngnix安装配置[亲测可用]