Home > Database > Mysql Tutorial > mysqld: unknown variable default-character-set=utf8

mysqld: unknown variable default-character-set=utf8

WBOY
Release: 2016-06-07 17:52:16
Original
1404 people have browsed it

mysqld: unknown variable default-character-set=utf8 解决方法有需要的朋友可参考一下。

在使用mysql5.5时按照以前5.1的方法来修改my.cnf文件,但是提示如下错误事件类型: 错误
事件来源: MySQL
事件种类: 无
事件 ID: 100
日期:  2012-11-14
事件:  12:00:12
用户:  N/A
计算机: SVCTAG-HZWGF3X
描述:
xxxbinmysqld: unknown variable 'default-character-set=utf8'

For more information, see Help and Support Center at http://www.mysql.com. 

查看事件查看器-应用程序,可看到mysql日志,点击进进看到:

xxxbinmysqld: unknown variable 'default-character-set=utf8'

For more information, see Help and Support Center at http://www.mysql.com. 

看来是 default-character-set=utf8这个设置项惹得祸....

后来得知 因为MYSQL 5.5修改了字符集设置参数

应该改成:

用character_set_server=utf8 取代default-character-set=utf8 

就 能解决这个问题

试了试,换掉 character_set_server=utf8

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template