mysql cluster admin permissions

Posted August 23, 2019 2.2k views

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?

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
2 answers

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.

What the hell ? Really ? To simply increase the max_connection limit of 75 to a more realistic value, the customer needs to contact the support ? What a fail.

  • yes, i didnt keep DO, went to AWS through Scalegrid, which gives you a true admin account, if they change the way they allow the setup i might go back