Related

Product Now Available: Managed MySQL Databases Product
Connection pooling is not supported? Question Question
Can I access database (mysql) logs? Question Question

Question

Functions and procedures creation

Posted August 28, 2020 128 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
*

Add a comment
jbarrios
By:
jbarrios
Add a comment

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
KFSys August 29, 2020

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.

Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help