Functions and procedures creation

Posted August 28, 2020 500 views
MySQLDigitalOcean Managed MySQL Database

How can i allow functions and triggers creation? currently it dont allow, shown the next error:
*SQL Error [1227] [42000]: Access denied; you need (at least one of) the SUPER or SETUSERID privilege(s) for this operation

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
1 answer

Hi @jbarrios,

Can you confirm how did you import/create your database, did you use the root user?

You’ll need to import/create your database using the ‘doadmin’ user in MySQL rather than root.