当前位置:   article > 正文

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

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;

声明:本文内容由网友自发贡献,不代表【wpsshop博客】立场,版权归原作者所有,本站不承担相应法律责任。如您发现有侵权的内容,请联系我们。转载请注明出处:https://www.wpsshop.cn/w/知新_RL/article/detail/819019
推荐阅读
相关标签
  

闽ICP备14008679号