MySQL常用命令：

一只懒得睁眼的猫

于 2017-09-13 12:02:26 发布

阅读量560

点赞数

分类专栏：数据仓库 MySQL数据库文章标签： mysql 常用命令

数据仓库同时被 2 个专栏收录

15 篇文章 1 订阅

订阅专栏

MySQL数据库

5 篇文章 0 订阅

订阅专栏

CREATE USER 'dbs'@'localhost' IDENTIFIED BY '123456'; 

SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query,Password FROM mysql.user;

GRANT ALL PRIVILEGES ON *.* TO 'dbs'@'%' IDENTIFIED BY PASSWORD '$Password' ;

GRANT ALL PRIVILEGES ON `dbs`.* TO 'dbs'@'%' WITH GRANT OPTION  ;


show grants for dbs;