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.
The doadmin user does not have RELOAD permissions as it could potentially break various configurations on the database.
At this time we do not support the change or modification of the lower_case_table_names variable, This value can actually only be configured when the MySQL server is initialized for the first time, so even if this setting was supported, it could not be changed for an existing service. We don’t currently have plans for adding support for it because there are some caveats related to this setting (in addition to the init-only nature of it).
For your reference, You can follow the below document :
As we continue to work on improving our products and services, we encourage you to share your thoughts, ideas, or feedback you have at https://ideas.digitalocean.com/ This will help us to better prioritize features that you feel need more attention.
I think you can set this in the my.cnf file;
typically in /etc/mysql/my.cnf
Then restart mysql.
Join 1M+ other developers and: