Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
Connection pooling is not supported? Question Question
Can I access database (mysql) logs? Question Question

Question

Functions and procedures creation

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

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
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.

×
Submit an Answer
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

Related

Looking for something else?

Ask a new question Search for more help