如何在mysql数据库中设置超级权限

Question

下面是创建视图查询

CREATE ALGORITHM=UNDEFINED DEFINER=`serve3_user465`@`%` SQL SECURITY DEFINER VIEW `constantcontact_customers_agents` AS select `customers`.`CustomerID` AS `CustomerID`,`customers`.`AgentID` AS `AgentID`,`customers`.`AccountType` AS `CustomerAccountType`,`customers`.`FirstName` AS `CustomerFirstName`,`customers`.`LastName` AS `CustomerLastName`,`customers`.`Address` AS `CustomerAddress`,`customers`.`City` AS `CustomerCity`,`customers`.`State` AS `CustomerState`,`customers`.`Zip` AS `CustomerZip`,`customers`.`Phone` AS `CustomerPhone`,`customers`.`Cell` AS `CustomerCell`,`customers`.`Fax` AS `CustomerFax`,`customers`.`Email` AS `CustomerEmail`,`customers`.`Dob` AS `CustomerDob`,`agents`.`FirstName` AS `AgentFirstName`,`agents`.`LastName` AS `AgentLastName`,`agents`.`CompanyName` AS `AgentCompanyName`,`agents`.`ApiUsername` AS `ApiUsername`,`agents`.`ApiPassword` AS `ApiPassword` from (`customers` join `agents` on((`customers`.`AgentID` = `agents`.`AgentID`))) where ((`agents`.`ApiUsern[...]

MySQL said: Documentation
#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation 

Answer 1

您需要以其他用户(具有'super‘权限的用户)身份登录，或者将super权限分配给您的用户

使用具有GRANT权限的用户连接到数据库，然后运行：

GRANT super ON *.* to 'your_user'@'%';

不过，您可能需要先检查分配超级权限的安全性问题

GRANT Syntax