Docker启动MySQL在log日志中发现报错unknown variable ‘default_character_set=utf8‘.

2023-05-16

问题: 前一天我将mysql配置好了,就关闭了,第二天重新启动mysql容器发现刚启动完,就停止掉了,很离谱!!!

解决方案: docker logs mysql 查看mysql日志,发现报错:
unknown variable ‘default_character_set=utf8’.
在这里插入图片描述
发现是配置文件的问题:
修改前配置文件是:

[mysqld]
skip-name-resolve
#default_character_set = utf8 //删掉此行
character_set_server=utf8
datadir=/var/lib/mysql
server-id=1000
[mysql]
default-character-set = utf8
[mysql.server]
default-character-set = utf8
[mysqld_safe]
default-character-set = utf8
[client]
default-character-set = utf8

修改后配置文件是:

[mysqld] 
skip-name-resolve
character_set_server=utf8
datadir=/var/lib/mysql
server-id=1000
[mysql] 
default-character-set = utf8
[mysql.server]
default-character-set = utf8
[mysqld_safe]
default-character-set = utf8
[client]
default-character-set = utf8
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)

Docker启动MySQL在log日志中发现报错unknown variable ‘default_character_set=utf8‘. 的相关文章

随机推荐