修改mysql字符编码出现Job failed to start解决办法
来源:互联网 发布:单片机做交通灯 编辑:程序博客网 时间:2024/05/21 07:57
从网上找到如下资料:
$sudo gedit /etc/mysql/my.cnf
[client]下添加:
default-character-set=utf8
[mysqld]下添加:
default-character-set=utf8
然后保存退出
$ /etc/init.d/mysql restart
结果出现了:
Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the stop(8) and then start(8) utilities,
e.g. stop mysql ; start mysql. The restart(8) utility is also available.
start: Job failed to start
----------------------------------------------------------------------------------------------------------------------------
可能是版本的问题,查5.5以后的版本对字符编码方式修改的办法,发现[mysqld]修改方法变了:
[mysqld]下添加的应该为:
character-set-server=utf8
collation-server=utf8_general_ci
保存退出
$ /etc/init.d/mysql restart
成功
进入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.00 sec)
- 修改mysql字符编码出现Job failed to start解决办法
- 修改mysql字符编码出现Job failed to start解决办法
- 修改mysql字符编码出现Job failed to start解决办法
- 修改mysql字符编码出现Job failed to start解决办法
- 修改mysql字符编码出现Job failed to start解决办法
- ubuntu上修改mysql默认字符编码出现的Job failed to start解决方法
- ubuntu上修改mysql默认字符编码出现的Job failed to start解决方法
- ubuntu下修改mysql默认字符编码出现的Job failed to start的解决方法
- ubuntu上修改mysql默认字符编码出现的Job failed to start解决方法
- ubuntu上修改mysql默认字符编码出现的Job failed to start解决方法
- mysql -- start: Job failed to start
- 【笔记】mysql failed to start job
- Job failed to start
- ubuntu下mysql start: Job failed to start解决
- mysql 无法启动提示 start: Job failed to start
- 安装VMware-tools出现initctl: Job failed to start
- mysql daemon failed to start 解决办法
- mysql job failed to start-tomcat问题变种
- 摇一摇
- 中国邮政储蓄银行网上银行转账时出现undefined 怎么办?
- airplay 逆向工程
- Qt + CURL + mimetic 发送邮件(带附件)
- 为什么我离不开 Linux?
- 修改mysql字符编码出现Job failed to start解决办法
- HDU-1455 Sticks 经典dfs剪枝
- Source Insight
- linux下多线程的创建与等待详解
- NSString+NSMutableString+NSValue+NSAraay用法汇总
- web工程中的web.xml文件有什么作用呢?
- 程序员编程艺术:第七章、求连续子数组的最大和
- Android特效开发(仿zaker用手向上推动的效果(推动门效果))
- 关于solr schema.xml 和solrconfig.xml的解释