MYSQL5.5修改字符集报错:unknown variable 'default-character-set=utf8'
linux-dash
A beautiful web dashboard for Linux
项目地址:https://gitcode.com/gh_mirrors/li/linux-dash

·
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




A beautiful web dashboard for Linux
最近提交(Master分支:7 个月前 )
186a802e
added ecosystem file for PM2 5 年前
5def40a3
Add host customization support for the NodeJS version 5 年前
更多推荐
所有评论(0)