Character set 'utf-8' is not a compiled character set and is not specified in the '/usr/share/mysql/

将my.ini（window） 或者my.cnf中

default-character-set = utf-8

改为

default-character-set = utf8

即可.

linux批量替换的语法：%s/old/new/g

例子：     :%s/utf-8/utf8/g;