Results 1 to 7 of 7

Thread: MySQL TRIGGERs

  1. #1
    poc16 is offline Junior Member
    Join Date
    Nov 2010
    Posts
    3

    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
    poc16 is offline Junior Member
    Join Date
    Nov 2010
    Posts
    3

    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
    poc16 is offline Junior Member
    Join Date
    Nov 2010
    Posts
    3

    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
    got18gt is offline Junior Member
    Join Date
    Oct 2010
    Posts
    1

    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 11: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