问题背景
mysql环境变量已经配置好,cmd命令行输入mysql命令时提示错误:Character set ‘utf-8’ is not a compiled character set and is not specified in the ‘/usr/share/mysql/charsets/Index.xml’ file
问题解决
Character set ‘utf-8’ is not a compiled character set and is not specified in the ‘/usr/share/mysql/charsets/Index.xml’ file表示:/usr/share/mysql/charsets/Index.xml文件确实编码集utf-8,但是检查后发现有编码,好像不是这里的问题.
于是又去网上搜索了一下,将mysql安装目录下的my.ini文件的default-character-set=utf-8更改为了default-character-set=utf8,在cmd命令行界面输入mysql命令就起作用了(不知道为啥这样就好了,有知道的留言告知一下)。