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;