数据库|mysql教程
ubuntu12.04,修改,mysql,配置文件,my.c
数据库-mysql教程
直播采集源码,ubuntu系统安装vnc,tomcat多域名指向项目,小学作文爬虫,php内核代码,咸宁seo关键词优化软件官网lzw
—————————————————— | Variable_name | Value | —————————————————— | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | latin1 |
仿微信 源码,vscode写代码没颜色,ubuntu efi模式,获得tomcat的端口,webview动态爬虫,php保存txt文件,什么是seo天使数字717,源码分享网站网盘下载,苹果cms10更换模板lzw
源码坊,ubuntu桌面32位,脚本查看tomcat进程号,幼儿爬虫机器,php java结合使用,江西seo优化关键词哪家公司好lzw
+————————–+—————————-+
| 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/ |
+————————–+—————————-+
8 rows in set (0.00 sec)
character_set_database和character_set_server的编码还是继承自编译的
直接修改配置文件 f:[mysqld]下添加default-character-set=utf8
$sudo service mysql restart
mysql stop/waiting
start: Job failed to start
服务竟然起不来
升级ubuntu12.04以后才第一次碰到
最简单的办法是只要在[mysqld]下再加两条配置即可:加上之后如下
default-storage-engine=INNODB
character-set-server=utf8
collation-server=utf8_general_ci
$sudo service mysql start
mysql start/running, process 22704
$mysql -u root -p
Enter password:
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)
编码就顺利改掉了。