- 论坛徽章:
- 0
|
mysql 5.0.24无法创建触发器,提示如下
用test用户进入
mysql> use test;
mysql> DELIMITER //
mysql> CREATE TRIGGER `test`.`test_admin` BEFORE INSERT ON `test`.`admin`
-> FOR EACH ROW BEGIN
-> SET NEW.id = uuid();
-> END
-> //
ERROR 1227 (42000): Access denied; you need the SUPER privilege for this operation
mysql> DELIMITER ;
mysql>
我
grant SUPER on test.* to test@localhost ;
mysql> select Host,Super_priv from user where User='test' and Host="localhost" ;
+-----------+------------+
| Host | Super_priv |
+-----------+------------+
| localhost | Y |
+-----------+------------+
1 row in set (0.00 sec)
请问这如何解决呢? |
|