Reply to comment

Create trigger MySQL 5.0 - super privilege required

Submitted by Tim Hollobon on Thu, 01/08/2009 - 11:50

In one of our C++ applications we programmatically create and write a trigger to the database. The application is designed to connect to Microsoft SQL Server, Oracle and MySQL 5.0.

When connected to MySQL 5.0, when the code attempted to create the trigger the following error was returned:



ERROR 1227 (42000): Access denied; you need the SUPER privilege for this operation

To grant the super privilege to the MySQL user, use the MySQL Query browser and connect to the database that the user needs super privilege. Then execute the following command:

grant super on *.* to Tim

If you ever want to revoke the super privilege from the user you can use:

revoke super on *.* from Tim

Reply