Results 1 to 7 of 7

Thread: MySQL TRIGGERs

  1. #1
    Guest

    Default 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):
    Code:
    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

  2. #2
    Gianluca is offline Administrator
    Join Date
    Feb 2010
    Posts
    512

    Default

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

    Thanks for your feedback

  3. #3
    Guest

    Default

    Quote Originally Posted by Gianluca View Post
    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.

  4. #4
    Guest

    Default

    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

  5. #5
    Guest

    Default

    Quote Originally Posted by Gianluca View Post
    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

  6. #6
    Guest

    Exclamation

    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 ????
    Last edited by ac1; 03-18-2011 at 10:38 AM. Reason: anybody answer

  7. #7
    Gianluca is offline Administrator
    Join Date
    Feb 2010
    Posts
    512

    Default

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

SEO by vBSEO