How to change MySQL database settings

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

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.

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.

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 :

As we continue to work on improving our products and services, we encourage you to share your thoughts, ideas, or feedback you have at 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.