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.

×
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.

Submit an Answer