8 lines
373 B
MySQL
8 lines
373 B
MySQL
|
drop database if exists litemall;
|
|||
|
|
drop user if exists 'litemall'@'%';
|
|||
|
|
-- 支持emoji：需要mysql数据库参数： character_set_server=utf8mb4
|
|||
|
|
create database litemall default character set utf8mb4 collate utf8mb4_unicode_ci;
|
|||
|
|
use litemall;
|
|||
|
|
create user 'litemall'@'%' identified by 'litemall123456';
|
|||
|
|
grant all privileges on litemall.* to 'litemall'@'%';
|
|||
|
|
flush privileges;
|