mysql的Trigger相关 （1142）

zhgc

报错：  

错误代码： 1142

1. TRIGGER command denied to user 'root'@'127.0.0.1' for table 'c_emp_desc_t'

复制代码

检验方法：

使用该用户来登陆mysql，然后执行以下命令：

1. show triggers;   

复制代码

如果没有显示，再查看改用户的所有权限：

1. show grants for username@'localhost';

复制代码

得到的数据
GRANT SELECT,
INSERT,
UPDATE,
DELETE,
CREATE,
DROP,
RELOAD,
SHUTDOWN,
PROCESS,
FILE,
REFERENCES,
INDEX,
ALTER,
SHOW DATABASES,
SUPER,
CREATE TEMPORARY TABLES,
LOCK TABLES,
EXECUTE,
REPLICATION SLAVE,
REPLICATION CLIENT,
CREATE VIEW,
SHOW VIEW,
CREATE ROUTINE,
ALTER ROUTINE,
CREATE USER ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD '*79C22367100E19797D30BFAEDB3290B76C095149' WITH GRANT OPTION


##为用户申请触发器权限：

grant TRIGGER on dbname.abcd_table to root@'%' identified by 'PASS';
grant TRIGGER on dbname.abcd_table to root@'localhost' identified by 'PASS';