How to change MySQL database settings

Posted March 2, 2020 1.8k views
DigitalOcean Managed MySQL Database
  1. Grant RELOAD to user doadmin
  2. Set variable 'lower_case_table_names' to 1

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.

Submit an Answer
1 answer

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

Then restart mysql.