use Perl

• That's for CREATE, not running (Score:2)

  by autarch (914)

  Reading the docs, it seems like it's just for creating the triggers, not executing them.
  • Re: (Score:2)

    by Ovid (2709)

    Sorry, but not quite correct. It's a pain to read through, but this is the killer:

    At trigger activation time, privileges are checked against the DEFINER user. This user must have these privileges:

    • The TRIGGER privilege. (SUPER prior to MySQL 5.1.6.)
    • The SELECT privilege for the subject table if references to table columns occur via OLD.col_name or NEW.col_name in the trigger definition.
    • The UPDATE privilege for the subject table if table columns are targets of SET NEW.col_name = value assignments in the trigger definition.
    • Whatever other privileges normally are required for the statements executed by the trigger.

    That was not fun to track down, but there ya go.
    • Re: (Score:2)

      by autarch (914)

      Ugh, MySQL is _so_ lame.
    • Re: (Score:2)

      by TeeJay (2309)

      Have you tested that? .. as it still seems to apply the privilege tests to the user that defined the trigger, rather than the user invoking it.

      --
      
      @JAPH = qw(Hacker Perl Another Just);
      print reverse @JAPH;
    • Re: (Score:1)

      by grink (8549)

      Like Teejay said, DEFINER

      Are you seeing something we're missing?
• Bartek Jakubski (Score:1)

  by migo (4937)

  We are using MySQL 5.0 heavily and I can assure you that running triggers does NOT require SUPER privileges. There are plenty of reasons to hate MySQL, but this is not one of them :-)
• use the sandbox (Score:1)

  by mapopa (4677)

  you can use sandbox to create and 5.1 db and then access it with an port number something like localhost:10000 http://www.howtoforge.com/quick-db-setups-with-mysql-sandbox [howtoforge.com] also everything on your host remains unchanged the other mysql will run on 3306 as usual ps: i wish we had in firebird something similar to sandbox it's easy to create an script that starts multiple/versions/db servers

  --
  flamerobin.org
• Finally! (Score:1)

  by manilodisan (9385)

  The only host I found so far to support mysql triggers on shared packages is at [url=http://www.placehost.net]placehost.net[/url]. I hope more will come. This is probably because hosting providers wait for plesk or cpanel to support such versions of PHP/MySql and those two are moving slower than anything else. PHP 5.2.9 came out recently and a lot of bugs were fixed yet nor cpanel or plesk supports this version.