MySQL create database 新建utf-8/utf8mb4编码 数据库

创建utf8编码 数据库

CREATE DATABASE IF NOT EXISTS yourdbname DEFAULT CHARSET utf8 COLLATE utf8_general_ci;

如果要创建默认gbk字符集的数据库可以用下面的sql:

create database yourdb DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;

创建 utf8mb4编码 数据库

create database sina default character set utf8mb4 collate utf8mb4_unicode_ci;

或者

create database confluence default character set utf8mb4 collate utf8mb4_bin;

修改用alter

create user jumpserver identified by 'n6vVsh0RlKJZTNV7C48agGno';

grant all privileges on jumpserver.* to 'jumpserver'@'localhost' identified by 'n6vVsh0RlKJZTNV7C48agGno' with grant option;

flush privileges;