Bug #30973 CREATE TRIGGER is not functioning
Submitted: 12 Sep 2007 13:05 Modified: 12 Oct 2007 13:41
Reporter: Benjamin Howarth Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Server: Information schema Severity:S2 (Serious)
Version:6.0.0-alpha-community-debug OS:Microsoft Windows (2003 Enterprise Edition)
Assigned to: CPU Architecture:Any
Tags: create, Event, schema, trigger

[12 Sep 2007 13:05] Benjamin Howarth
When I try to grant permissions for TRIGGER and EVENT on any schema for a user, the UI appears to accept this but when the schema is refreshed the granted permissions for TRIGGER and EVENT disappear, and when using CREATE TRIGGER get a "permission denied" error for all users.
This happens with all users, including sa.

How to repeat:
See above

Suggested fix:
No ideas, never come across problem before.
[12 Sep 2007 13:41] Miguel Solorzano
Thank you for the bug report. Could you please try with the last released
version 6,0.2-alpha and if you still get the same behavior please provide
the exact step you did to try to repeat on our side. Thanks in advance.
[12 Oct 2007 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".