MySQL TRIGGERs

Hi!

I am not allowed to use TRIGGERs on my database.

If I execute the following code (from http://dev.mysql.com/doc/refman/5.1/...trigger.html):

CREATE TABLE test1(a1 INT);
CREATE TABLE test2(a2 INT);
CREATE TABLE test3(a3 INT NOT NULL AUTO_INCREMENT PRIMARY KEY);
CREATE TABLE test4(
  a4 INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  b4 INT DEFAULT 0
);

delimiter |

CREATE TRIGGER testref BEFORE INSERT ON test1
  FOR EACH ROW BEGIN
    INSERT INTO test2 SET a2 = NEW.a1;
    DELETE FROM test3 WHERE a3 = NEW.a1;
    UPDATE test4 SET b4 = b4 + 1 WHERE a4 = NEW.a1;
  END;
|

delimiter ;

INSERT INTO test3 (a3) VALUES
  (NULL), (NULL), (NULL), (NULL), (NULL),
  (NULL), (NULL), (NULL), (NULL), (NULL);

INSERT INTO test4 (a4) VALUES
  (0), (0), (0), (0), (0), (0), (0), (0), (0), (0);

I'll get: "#1142 - TRIGGER command denied to user 'poc16'@'localhost' for table 'test1' "

Is it possible to GRANT all users of this hosting (So including me ) the TRIGGER privilege? TRIGGERs are really nice to use and I don't want to miss them.

Thanks in advance.
Jan

[Gianluca]

We plan to add this feature soon, please keep an eye to this forum...

Thanks for your feedback

We plan to add this feature soon, please keep an eye to this forum...

Thanks for your feedback

Ok, will do so.

Thanks for your answer.

Hi!

Sorry for being so impatient, but is there any progress on this topic?

If not, is it possible for you to specify a timeframe?

Thanks,
Jan

We plan to add this feature soon, please keep an eye to this forum...

Thanks for your feedback

Hi,

Is there any chance this feature will be enabled soon?

Thank you.

Regards,
Danny

I'm having the same problem running the instal.php (galaxytool)
Is there a solution ?

Table: u42_players (Trigger 1) failure
TRIGGER command denied to user 'ac1'@'localhost' for table 'u42_players'
Table: u42_players (Trigger 2) failure
TRIGGER command denied to user 'ac1'@'localhost' for table 'u42_players'
Table: u42_alliances (Trigger 1) failure
TRIGGER command denied to user 'ac1'@'localhost' for table 'u42_alliances'
Table: u42_alliances (Trigger 2) failure
TRIGGER command denied to user 'ac1'@'localhost' for table 'u42_alliances'
Table: u42_reports (Trigger 1) failure
TRIGGER command denied to user 'ac1'@'localhost' for table 'u42_reports'
Table: u42_reports (Trigger 2) failure
TRIGGER command denied to user 'ac1'@'localhost' for table 'u42_reports'
Installation failed

-------


Anybody here ????

[Gianluca]

The feature has been added, you can find a switch in your control panel AlterSite -> Resource & Upgrades -> Database