set user & password for database 设置数据库 用户和密码

DROP DATABASE IF EXISTS sbms;
CREATE DATABASE sbms DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
USE sbms;

DROP USER IF EXISTS ‘sbms’;
CREATE USER ‘sbms’ IDENTIFIED BY ‘sbms@123!’;
grant all privileges on sbms.* to ‘sbms’@‘%’;
FLUSH PRIVILEGES;