Question

How to change MySQL database settings

  1. Grant RELOAD to user doadmin
  2. Set variable 'lower_case_table_names' to 1
Subscribe
Share

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

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.

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

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

Then restart mysql.