COLLATION 'latin1_swedish_ci' is not valid for CHARACTER SET 'utf8'

初始化 加上参数

--collation-server=utf8_general_ci

初始化

./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/  --datadir=/usr/local/mysql/data/mysqldb/ --explicit_defaults_for_timestamp=true --collation-server=utf8_general_ci
原文地址:https://www.cnblogs.com/buxiangxin/p/7218652.html