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 372 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

Related

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

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