在mysql中创建触发器的权限 [英] Permissions for creating a trigger in mysql

问题描述

mysql ver是5.0.67

mysql ver is 5.0.67

我的触发代码是:

DELIMITER //
CREATE TRIGGER upd_price BEFORE UPDATE ON product_price
 FOR EACH ROW BEGIN  
    INSERT INTO update_price_log (product_id, product_price_old, product_price_new) values(OLD.product_id, OLD.product_price, NEW.product_price);
END
//
DELIMITER ;

错误是:

#1227-访问被拒绝；您需要SUPER权限才能执行此操作

#1227 - Access denied; you need the SUPER privilege for this operation

我的服务器不是cpanel！ 它是:DirectAdmin Web控制面板.

my server, is not cpanel! it is : DirectAdmin Web Control Panel.

我如何创建SUPER特权并创建触发器?

how can i create SUPER privilege and create my trigger?

推荐答案

您必须具有MySQL Root特权才能为用户设置SUPER权限.

You must have MySQL Root privileges to set the SUPER permission for a user.

GRANT SUPER 
ON '<database>'.'<tablename/*>' 
TO '<username>'@'<host/connection/ip/%>'; 

这篇关于在mysql中创建触发器的权限的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！