如何将所有SHOW权限添加到用户

Question

添加用户权限时遇到问题。输入后：

CREATE USER 'operator'@'localhost' IDENTIFIED BY '7gx8vq95wqgu3qcp';
GRANT SELECT, INSERT, UPDATE, DELETE, SHOW, CREATE ON AGD.* TO 'operator'@'localhost';

弹出语法错误。我想是关于这个部分：

SHOW

我想添加这些权限：选择、更新插入、删除、全部显示和全部创建。不幸的是，我在网上找不到它。如果你帮我做这件事，我将不胜感激。

Answer 1

您必须在之间进行选择

CREATE USER 'operator'@'localhost' IDENTIFIED BY '7gx8vq95wqgu3qcp';
GRANT SELECT, INSERT, UPDATE, DELETE, SHOW DATABASES, CREATE ON AGD.* TO 'operator'@'localhost';
CREATE USER 'operator'@'localhost' IDENTIFIED BY '7gx8vq95wqgu3qcp';
GRANT SELECT, INSERT, UPDATE, DELETE, SHOW VIEW, CREATE ON AGD.* TO 'operator'@'localhost';

查看所有特权