weixin_42562106的博客

tee mysqldb.yaml <<-'EOF'apiVersion: apps/v1kind: StatefulSetmetadata: name: mysql-sz namespace: ops labels: app: mysqlszspec: selector: matchLabels: app: mysqlsz serviceName: mysqlsz replicas: 1 template: metadata

#!/bin/bashu="root"p="bBQycPgI4YV2"link="rm-3n21.mysql.rds.aliyuncs.com"database=`mysql -P3300 -u${u} -p${p} -h${link} -e "show databases"|grep -Ev "Database|information_schema|mysql|sys|performance_schema"`for data in ${database}do echo $data m

如果仍有编码不是utf8的，请检查配置文件，也可使用mysql命令设置：set character_set_client = utf8;set character_set_server = utf8;set character_set_connection = utf8;set character_set_database = utf8;set character_set_results = utf8;set collation_connection = utf8_general_ci