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
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