How to change MySQL database settings

I think you can set this in the my.cnf file; typically in /etc/mysql/my.cnf

Then restart mysql.

Hi @jeremiehornus,

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 :

https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_lower_case_table_names

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.

Regards, Rajkishore