/usr/bin/mysqld: unknown variable 'default-character-set=utf8'的解决
来源:互联网 发布:谷歌程序员常用插件 编辑:程序博客网 时间:2024/05/16 15:34
通过rpm包的方式安装了MySQL-server-5.5.11,直接在命令行输入service mysql start,启动mysql成功,
然后修改/etc/my.cnf,给[mysqld]下增加了default-character-set=utf8,再重启mysql服务,这时候报错:
Starting MySQL............The server quit without updating PID file (/var/lib/mysql/node1.pid). [faild]
查看日志/var/log/mysql.log,发现其中提示:
/usr/bin/mysqld: unknown variable 'default-character-set=utf8'
看来是default-character-set=utf8这个设置项惹得祸....
在网上搜索一番,发现有人提出,用character_set_server=utf8来取代default-character-set=utf8 能解决这个问题,
试了试,换掉character_set_server=utf8,再启动果然没问题了...
- /usr/bin/mysqld: unknown variable 'default-character-set=utf8'的解决
- mysql_error.log:[ERROR] mysql\bin\mysqld.exe: 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'
- MySQL mysqlbinlog查看binlog时报错unknown variable 'default-character-set=utf8'解决
- MySQL mysqlbinlog查看binlog时报错unknown variable 'default-character-set=utf8'解决
- 解决mysqlbinlog: unknown variable 'default-character-set=utf8mb4'问题
- unknown variable 'default-charater-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'
- MYSQL5.5修改字符集报错:unknown variable 'default-character-set=utf8'
- mysqlbinlog 查看binlog时报错unknown variable 'default-character-set=utf8'
- mysqlbinlog 查看binlog时报错unknown variable 'default-character-set=utf8'
- erlang经典网站
- session 与cookie
- android的源码结构
- word转PDF
- oracle的date类型数据 我是这么认为
- /usr/bin/mysqld: unknown variable 'default-character-set=utf8'的解决
- 深入Java中文编码乱码问题及最优解决方法
- uva 11402 ahoy pirates
- lucene的多个字段搜索以及分页并高亮显示
- [Linux学习笔记]VirtualBox安装CentOS
- 更改内核的启动画面
- VS2005(C#)里读取及改变App.config里appSettings节的值
- std string 的常用使用
- linux上更改TCP窗口大小