create table:

CREATE DATABASE mydatabase CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

login with utf8

mysql -uroot -h127.0.0.1 -P3306 -p database --default-character-set=utf8  # 使用utf8编码登录

https://dba.stackexchange.com/a/76789/174516

posted on 2019-05-29 17:40  Go_Forward  阅读(100)  评论(0编辑  收藏  举报