MySQL: Skill: Add all privileges for user abc on database basic_data

原创于 2019-02-19 14:29:04 发布 · 274 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#MySQL #privileges #GRANT #command #skill

Command 同时被 3 个专栏收录

87 篇文章

订阅专栏

Skill

54 篇文章

订阅专栏

MySQL

36 篇文章

订阅专栏

本文详细介绍了如何在MySQL中为用户abc授予basic_data数据库的所有权限，并展示了使用SHOW GRANTS命令查看用户abc的具体权限设置。

MySQL: Add all privileges for user abc on database basic_data

SHOW GRANTS FOR abc;
//results
GRANT USAGE ON *.* TO 'abc'@'%' IDENTIFIED BY PASSWORD '*38E573FEE0457F38F79B14E4E5381EAA895B5FC1'
GRANT SELECT ON `mysql`.`proc` TO 'abc'@'%'

GRANT ALL PRIVILEGES ON `basic_data`.* TO 'abc'@'%';

SHOW GRANTS FOR abc;
//results
GRANT USAGE ON *.* TO 'abc'@'%' IDENTIFIED BY PASSWORD '*38E573FEE0457F38F79B14E4E5381EAA895B5FC1'
GRANT ALL PRIVILEGES ON `basic_data`.* TO 'abc'@'%'
GRANT SELECT ON `mysql`.`proc` TO 'abc'@'%'