mysql: character set in mysql 8.0

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

-- https://dev.mysql.com/doc/refman/8.0/en/charset-database.html show variables like "character_set_%";   CREATE DATABASE `geovindu` CHARACTER SET utf8 COLLATE utf8_general_ci; -- mysql官方说明文档才知道原来MySQL8.0已经已经把默认字符集升级成ut8mb4了   ALTER DATABASE geovindu     DEFAULT CHARACTER SET utf8     DEFAULT COLLATE utf8_general_ci ;     SELECT DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'geovindu';   USE geovindu;                                              SELECT @@character_set_database, @@collation_database;

　　

 

ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;