Question

mysql cluster admin permissions

Posted August 23, 2019 520 views
Ubuntu DigitalOcean

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?

Add a comment
fris
By:
fris
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.

2 answers
ServerEnthusiast August 26, 2019

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.

Reply Report
csesli0511 November 30, 2019

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.

Reply Report
  • fris November 30, 2019

    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

    Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help