向数据库导入triggerDELIMITER |
CREATE TRIGGER testref
BEFORE INSERT ON testdb.sell
FOR EACH ROW
BEGIN
set new.sortorder=1;
END;
|
ERROR 1142 (42000) at line 2: TRIGGER command denied to user 'test_sql'@' .......已经分配所有权限GRANT ALL PRIVILEGES ON testdb.* TO 'test_sql'@'%' IDENTIFIED BY 'test_sql';为啥还是不行?
CREATE TRIGGER testref
BEFORE INSERT ON testdb.sell
FOR EACH ROW
BEGIN
set new.sortorder=1;
END;
|
ERROR 1142 (42000) at line 2: TRIGGER command denied to user 'test_sql'@' .......已经分配所有权限GRANT ALL PRIVILEGES ON testdb.* TO 'test_sql'@'%' IDENTIFIED BY 'test_sql';为啥还是不行?
解决方案 »
- mysql主从同步master.info保存的信息
- 请教mysql存储过程:第一列按表某字段统计
- 为什么我的这个Navicat for MySQL连接不起呢??!!!!每次都出现2003-Can't connect to MySQL on 'localhost; (10061) 请哪位好心人告诉我答案好妈???
- 字数统计
- 创建表的问题
- 大批量数据下如何做一个高效的重复数据检测
- 一个Hibernate一对多产生的问题
- 求一查询语句,马上给分
- 怎样使用mysql的jdbc驱动程序?
- 链接
- 在线求:一道sql问题!!
- !!!在线急等!!sqlserver中如何知道一个job的运行状态,请大侠指教,多谢!!!!!!!
SELECT CURRENT_USER();
root 没在我手上,别人给我 (test_sql) 分配权限
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPO
RARY TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE ON ....确实没有trigger, 这个要单独加上么?
At CREATE TRIGGER time, the user that issues the statement must have the TRIGGER privilege. (SUPER prior to MySQL 5.1.6.)
TEMPORARY TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTIN
E ON *.* TO 'test_sql'@'%' IDENTIFIED BY PASSWORD '*2D9CDE7A1E329BEF006418E263C3
6B56674DB1A9' |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPO
RARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER
ROUTINE, TRIGGER ON `ddfw`.* TO 'test_sql'@'%' WITH GRANT OPTION
|貌似加上了,但是还是报同样错
mysql> select current_user();
+----------------+
| current_user() |
+----------------+
| test_sql@% |
+----------------+
还是老样子 TRIGGER command denied to user 'test_sql'@'这里是某ip' for table 'sell'
MySQL的授权是 用户名+主机名
新增这样的用户,再授权试试
[email protected]