Heim >Datenbank >MySQL-Tutorial >linux下的mysql修改默认编码
linux下的mysql修改默认编码
- WBOYOriginal
- 2016-06-07 15:01:26974Durchsuche
欢迎进入Linux社区论坛，与200万技术人员互动交流 >>进入 安装mysql sudo apt-get install mysql-server 查看mysql默认编码 show variables like 'character%'; +--------------------------+----------------------------+ | Variable_name | Value | +----
欢迎进入Linux社区论坛，与200万技术人员互动交流 >>进入
安装mysql
sudo apt-get install mysql-server
查看mysql默认编码
show variables like 'character%';
+--------------------------+----------------------------+
| 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/ |
+--------------------------+----------------------------+
修改mysql的默认编码
sudo gedit /etc/mysql/my.cnf
在[mysqld]
#
# * Basic Settings
#
下面加上
character_set_server=utf8
修改完成后保存然后重启mysql
sudo /etc/init.d/mysql restart
