在doc登陆mysql提示Character set 'utf-8' is not a compiled character set and is not specified

参考https://www.cnblogs.com/ahacn/archive/2011/12/24/2300532.html

1,错误重现

安装好mysql后进入doc,进入mysql安装目录,然后输入mysql -u root -p 提示以下错误

在doc登陆mysql提示Character set 'utf-8' is not a compiled character set and is not specified

2,处理方法

在mysql安装目录下找到my.int,

在doc登陆mysql提示Character set 'utf-8' is not a compiled character set and is not specified

打开找到default-character-set=utf-8改成default-character-set=utf8后,保存

在doc登陆mysql提示Character set 'utf-8' is not a compiled character set and is not specified

3,验证

在doc登陆mysql提示Character set 'utf-8' is not a compiled character set and is not specified

输入密码后就可以