image.png
解决办法：
SHOW CREATE DATABASE ambari;
ALTER DATABASE ambari DEFAULT CHARACTER SET utf8;
SHOW CREATE TABLE ambari.serviceconfig;
ALTER TABLE ambari.serviceconfig; CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
发现还是有其他的表会报错：
删除表，并重新新建表，设置其utf8
drop database ambari;
create database ambari DEFAULT CHARACTER SET utf8;
重新导入表
use ambari;
source /var/lib/ambari-server/resources/Ambari-DDL-MySQL-CREATE.sql
重启mysql。问题解决
======================
参考：https://blog.csdn.net/u011553945/article/details/103716545
[mysql用sql语句创建表和数据 设置字符编码为utf-8]：
https://www.cnblogs.com/expedition/p/11406966.html
网友评论