mysql: character set in mysql 8.0

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