mysql right

最新推荐文章于 2025-04-23 00:59:34 发布

spencer_tseng

最新推荐文章于 2025-04-23 00:59:34 发布

阅读量128

点赞数

分类专栏： mysql

本文链接：https://blog.youkuaiyun.com/spencer_tseng/article/details/117937505

版权

mysql 专栏收录该内容

57 篇文章

订阅专栏

/*------------------------------------------------------------------------
--@desc 创建用户zengwenfeng初始化密码123456 
        并且授予用户zengwenfeng访问数据库zwf所有表的仅仅查询权限
--@author ZengWenfeng
--@date 2021.06.15
------------------------------------------------------------------------*/
GRANT SELECT ON zwf.* TO 'zengwenfeng'@'localhost' IDENTIFIED BY '123456';
COMMIT;

/*--------------------------------------------------------------------------------------------------------------------*/

/*------------------------------------------------------------------------
--@desc 创建用户zengwenfeng初始化密码123456
--@author ZengWenfeng
--@date 2021.06.15
------------------------------------------------------------------------*/
CREATE USER 'zengwenfeng'@'localhost' IDENTIFIED BY '123456';
COMMIT;


/*------------------------------------------------------------------------
--@desc 授予用户zengwenfeng访问数据库zwf所有表的仅仅查询权限
--@author ZengWenfeng
--@date 2021.06.15
------------------------------------------------------------------------*/
GRANT SELECT ON zwf.* TO 'zengwenfeng'@'localhost';
COMMIT;