How To Set lower_case_table_names In MySQL On Ubuntu — 2024

Mark Harwood
3 min readMay 17, 2024

So I wanted to show how to set lower_case_table_names in MySQL on Ubuntu.

This is a really niche issue, I encountered it recently when trying to deploy an application that used MySQL 8.0.36 running on Ubuntu. The issue was that the application required lower case table names, something that MySQL doesn’t do by default and is a bit of a pain to rectify.

I’ll explain more in the intro!

Before we jump in, I’ve also written this post on my website in case you prefer reading over…

--

--

Mark Harwood

IT Pro 👨‍💻 Dad 👀 Husband🔒 Check out my free blog or utilise my expertise on the web! https://mharwood.uk