mysql cluster admin permissions

August 23, 2019 149 views
DigitalOcean Ubuntu

the mysql cluster service i find is lacking admin permissions, the doadmin account isnt a true admin account.

i cant even set the sql_mode via console.

ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER or SYSTEMVARIABLESADMIN privilege(s) for this operation

anyone know of a way i can do this?

1 Answer
iskamwebsite August 26, 2019
Accepted Answer

I don’t think that you get Admin privileges with the managed databases. That is the point of a managed service, you let the vendor do the management for you and you just deploy your databases. If you need root access, you could install MySQL on a normal droplet and manage and configure it yourself.

But maybe for specific values you could contact DigitalOcean support and ask them to change the value for you.

Have another answer? Share your knowledge.