本文展示了如何使用MySQL GRANT语句为不同的数据库用户分配特定权限。通过两个示例，演示了如何授权用户对数据库进行多种操作，如查看、修改、备份等。
grant SHOW VIEW,SELECT,RELOAD,SUPER,REPLICATION CLIENT on *.* to dbbk@localhost;
mysql> GRANT SELECT, INSERT, UPDATE, CREATE, DROP, RELOAD, SHUTDOWN, FILE, INDEX, ALTER, SUPER, LOCK TABLES, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, TRIGGER, CREATE ROUTINE, DELETE, EVENT, ALTER ROUTINE ON *.* TO 'backup-user'@'quartz.zmanda.com' IDENTIFIED BY 'zrmbackup';
mysql> GRANT SELECT, INSERT, UPDATE, CREATE, DROP, RELOAD, SHUTDOWN, FILE, INDEX, ALTER, SUPER, LOCK TABLES, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, TRIGGER, CREATE ROUTINE, DELETE, EVENT, ALTER ROUTINE ON *.* TO 'backup-user'@'quartz.zmanda.com' IDENTIFIED BY 'zrmbackup';
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
