mysql中创建数据库的sql语句有哪些

CREATE DATABASE database_name;

CREATE DATABASE database_name CHARACTER SET character_set_name COLLATE collation_name;

CREATE DATABASE database_name;
GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'localhost' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;

CREATE DATABASE database_name DEFAULT CHARACTER SET character_set_name DEFAULT COLLATE collation_name ENGINE=engine_name;

CREATE DATABASE database_name
    [[DEFAULT] CHARACTER SET character_set_name]
    [[DEFAULT] COLLATE collation_name]
    [COMMENT 'string']
    [ENCRYPTION [=] {'Y' | 'N'}]
    [EVENT_RETENTION = number]
    [PAGE_SIZE = number]
    [AUTO_INCREMENT [=] number]
    [MAX_ROWS [=] number]
    [MIN_ROWS [=] number]
    [AVG_ROW_LENGTH [=] number]
    [DATA DIRECTORY [=] 'directory']
    [INDEX DIRECTORY [=] 'directory']
    [DELAY_KEY_WRITE [=] {'Y' | 'N'}]
    [ROW_FORMAT [=] {DEFAULT | DYNAMIC | FIXED | COMPRESSED | REDUNDANT | COMPACT}]
    [TABLESPACE [=] tablespace_name]
    [STORAGE [=] {'DEFAULT' | 'DISK' | 'MEMORY'}]
    [TABLESPACE_STORAGE [=] {'DEFAULT' | 'DISK' | 'MEMORY'}]
    [CONNECTION [=] {'DEFAULT' | 'PERFORMANCE' | 'SCALABILITY' | 'REDUNDANCY' | 'PROXY'}]
    [UNDO_TABLESPACE [=] tablespace_name];