mysql5.7设置默认编码
来源:互联网 发布:凸优化中科大 编辑:程序博客网 时间:2024/05/29 13:35
1、通过 show variables like '%char%';查看MySQL字符集情况
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 | latin1 || character_set_system | utf8 || character_sets_dir | /usr/share/mysql/charsets/ |+--------------------------+----------------------------+
2、修改mysql配置文件
#备份配置文件sudo cp /etc/mysql/mysql.conf.d/mysqld.cnf /etc/mysql/mysql.conf.d/mysqld.cnf_2sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf# 修改处1:添加以下2行[client]default-character-set=utf8
[mysqld]
# 修改处2:添加以下3行default-storage-engine=INNODBcharacter-set-server=utf8collation-server=utf8_general_ci
3、重启mysqlservice mysql restart
4、查看字符集mysql -uroot -pmysql> show variables like "%char%";+--------------------------+----------------------------+| 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/ |+--------------------------+----------------------------+
阅读全文
0 0
- mysql5.7设置默认编码
- mysql5.7字符编码设置
- windows中mysql5.5.10默认字符集修改,字符编码设置
- 设置mysql5.7编码格式为UTF8
- MySQL5.7设置编码方式为utf8
- mysql5设置编码
- mysql5.6编码问题设置
- mysql5.5设置字符编码
- 设置mysql默认编码
- [putty]设置默认编码
- jsp默认编码设置
- eclipse设置默认编码
- eclipse设置默认编码
- MyEclipse默认编码设置
- mysql默认编码设置
- Python设置默认编码
- gedit默认编码设置
- Eclipse设置默认编码
- Java虚拟机架构——来自《Java虚拟机实战》的笔记
- Android mediaplayer_vadio视频
- 【 D3.js 视频系列 】 飞速入门
- Android studio卡顿问题
- 【登录异常解决】Ubuntu 输入正确的密码后重新返回到登陆界面
- mysql5.7设置默认编码
- LeetCode 39. Combination Sum
- LogCat日志不显示
- BZOJ 1067 降雨量 (线段树)
- webrtc详细介绍
- HTML5开发者心声:浏览器兼容性成最大问题
- onSaveInstanceState(Bundle outState)的调用时机
- 串级PID控制四轴飞行状态-分析
- 寻找矩阵行最大列最小元素