mssql创建用户，建库，授予远程登录权限语句

最新推荐文章于 2024-10-24 23:13:54 发布

weixin_34413357

最新推荐文章于 2024-10-24 23:13:54 发布

阅读量416

点赞数

文章标签：数据库 python

原文链接：https://my.oschina.net/u/2537743/blog/787774

版权

2019独角兽企业重金招聘Python工程师标准>>>

DROP DATABASE `wordpress`;

CREATE DATABASE `wordpress` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

CREATE USER 'xxxuser'@'localhost' IDENTIFIED BY 'xxx123';

GRANT USAGE ON * . * TO 'xxxuser'@'localhost' IDENTIFIED BY 'xxx123' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

GRANT ALL PRIVILEGES ON `wordpress` . * TO 'xxxuser'@'localhost' WITH GRANT OPTION ;

flush privileges;

转载于:https://my.oschina.net/u/2537743/blog/787774