Question

How to set global variable default_table_encryption in mysql managed database?

How to set global variable default_table_encryption in mysql managed database?


Submit an answer

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!

Sign In or Sign Up to Answer

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.

Hello,

The MySQL system variables are set depending upon the size of the cluster’s Droplets. You can’t edit them, but you can see what they are with SHOW VARIABLES;.

You could try reaching out to the DigitalOcean support team and cross-check if they could make such a change to the managed cluster for you:

https://www.digitalocean.com/support/

Regards, Bobby

Hi, I have the same issue with a MySQL 8 managed database.

I need to enable LOAD DATA LOCAL INFILE. I thought this would be possible through the control panel but the only thing that I can see there that can be tweaked is SQL mode. From the command, I could run SET GLOBAL local_infile = true; but I don’t have permissions for this.

Is there any other way to achieve this?