MYSQL5.5修改字符集报错:unknown variable 'default-character-set=utf8'
来源:互联网 发布:网络热门歌曲排行榜 编辑:程序博客网 时间:2024/06/06 00:33
Linux上安装了Mysq 5.5,在配置文件/etc/my.cnf中设置字符集:
default-character-set=utf8
结果启动失败,查看日志,里面有如下错误:
[ERROR] /usr/sbin/mysqld: unknown variable 'default-character-set=utf8'
用mysql连接数据库服务,用show variables like 'char%';查看,发现有好多跟字符集相关的变量。
在my.cnf中,设置了两行:
default-character-set=utf8
结果启动失败,查看日志,里面有如下错误:
[ERROR] /usr/sbin/mysqld: unknown variable 'default-character-set=utf8'
用mysql连接数据库服务,用show variables like 'char%';查看,发现有好多跟字符集相关的变量。
在my.cnf中,设置了两行:
character_set_database=utf8
character_set_server=utf8
结果还是提示不认识character_set_database,最后只保留
character_set_server=utf8
- MYSQL5.5修改字符集报错:unknown variable 'default-character-set=utf8'
- MYSQL5.5修改字符集报错:unknown variable 'default-character-set=utf8'
- MYSQL5.5修改字符集报错:unknown variable 'default-character-set=utf8'
- MYSQL5.5修改字符集报错:unknown variable 'default-character-set=utf8'
- MYSQL5.5修改字符集报错:unknown variable 'default-character-set=utf8'
- mysql启动报错 unknown variable 'default-character-set=utf8'
- MySQL Binlog (异常) unknown variable 'default-character-set=utf8'
- mysqlbinlog: unknown variable 'default-character-set=utf8'
- mysqlbinlog: unknown variable 'default-character-set=utf8'
- mysqlbinlog: unknown variable 'default-character-set=utf8'
- mysqlbinlog: unknown variable 'default-character-set=utf8'
- mysqlbinlog: unknown variable 'default-character-set=utf8'
- mysqlbinlog 查看binlog时报错unknown variable 'default-character-set=utf8'
- mysqlbinlog 查看binlog时报错unknown variable 'default-character-set=utf8'
- mysqlbinlog 查看binlog时报错unknown variable 'default-character-set=utf8'
- MySQL mysqlbinlog查看binlog时报错unknown variable 'default-character-set=utf8'解决
- linux下执行mysql时报错:unknown variable 'default-character-set=utf8'
- MySQL mysqlbinlog查看binlog时报错unknown variable 'default-character-set=utf8'解决
- 第十六周实验报告1
- MyEclipse提示键配置、提示快捷键、提示背景色、关键字颜色、代码显示、编...
- 顺序栈
- MAYA MEL 基础
- Cannot make a static reference to the non-static method xxx()
- MYSQL5.5修改字符集报错:unknown variable 'default-character-set=utf8'
- IE6 fixed的完美解决方案
- Ubuntu 软件包管理详解
- jsp tomcat 配置错误页
- 自己写的.Net(C#)代码自动生成器
- Linux IP代理筛选系统(shell+proxy)
- Extjs-examples-app-feedviewer中的通过feed-proxy.php改写的feed-proxy.jsp
- 几种函数调用方式
- 当在浏览器中输入一个url后回车,后台发生了什么?比如输入url后,你看到了百度的首页,那么这一切是如何发生的呢