By Arseniy
By default expire_logs_days is set to 0 in my DigitalOcean SQL database.
When executing “set global expire_logs_days=7;” command in MySQL Workbench i get an error “Error Code: 1227. Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation”
How can i get those permissions or is there any other way to change expire_logs_days value?
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Hi there,
The expire_logs_days value is not configurable for the Managed MySQL database clusters.
You can change only the following fields listed in the API documentation here:
https://docs.digitalocean.com/reference/api/api-reference/#operation/databases_patch_config
Can you confirm why do you need that specific value adjusted?
Best,
Bobby
Hi @arseniyaxolotl,
Unfortunately, the expire_logs_days variable is not something you can edit on the Managed Database platform. As a Managed Database, you don’t have full administrator access to it and similar values such as the expire_logs_days can’t be changed.
If you wish to see which values you can change/adjust, you can check the following API page:
https://docs.digitalocean.com/reference/api/api-reference/#operation/databases_patch_config
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.