- Joined
- 4 Jun 2021
- Messages
- 5,611 (4.51/day)
Today, I installed the latest MySQL 8.0.30 on my home PC for testing and development purposes.
I changed the default table case setting (variable "lower_case_table_names") from lower case, to Preserve Given Case as in the screenshot below, since I figured it would be better to allow mixed case table names. However, when I connected to my database using Workbench, I got a pop-up error that my computer doesn't fully meet the requirements of this setting, which will generate errors. This is no good as I'm going to be installing XenForo and other forum software on it, so I wanted to set it back to default without having to uninstall and reinstall the entire MySQL product.
Cue lots of reading up and frantic Googling on how to access these MySQL system variables and change their values. Finally, I figured it out (really complex product). Ran the command... variable is read only!
Turns out that some time back around version 8.0.11 apparently, MySQL no longer allows one to change this setting without uninstalling and reinstalling the whole product! It's all to do with data integrity apparently somehow, I dunno. What a PITA, I'm sure it's not so critical, especially on a brand new, unused database and they could allow the database admin who can be assumed to know what they're doing to take the risk with an informed decision. I couldn't find a physical configuration file for it, although it's apparently there and encrypted according to the manual, which is likely where it lives.
Sod it, that's enough hassle, so I've uninstalled it and am reinstalling it as I write this. Quite unsatisfying to jump through all these hoops only to be forced into doing the thing I was trying to avoid in the first place. Don'tcha just love design decisions that are a real pain when one false move is made? Answers on a postcard to the usual address. At least I learned a bit more about MySQL, so the time and effort is not completely wasted.
I changed the default table case setting (variable "lower_case_table_names") from lower case, to Preserve Given Case as in the screenshot below, since I figured it would be better to allow mixed case table names. However, when I connected to my database using Workbench, I got a pop-up error that my computer doesn't fully meet the requirements of this setting, which will generate errors. This is no good as I'm going to be installing XenForo and other forum software on it, so I wanted to set it back to default without having to uninstall and reinstall the entire MySQL product.
Cue lots of reading up and frantic Googling on how to access these MySQL system variables and change their values. Finally, I figured it out (really complex product). Ran the command... variable is read only!
Turns out that some time back around version 8.0.11 apparently, MySQL no longer allows one to change this setting without uninstalling and reinstalling the whole product! It's all to do with data integrity apparently somehow, I dunno. What a PITA, I'm sure it's not so critical, especially on a brand new, unused database and they could allow the database admin who can be assumed to know what they're doing to take the risk with an informed decision. I couldn't find a physical configuration file for it, although it's apparently there and encrypted according to the manual, which is likely where it lives.
Sod it, that's enough hassle, so I've uninstalled it and am reinstalling it as I write this. Quite unsatisfying to jump through all these hoops only to be forced into doing the thing I was trying to avoid in the first place. Don'tcha just love design decisions that are a real pain when one false move is made? Answers on a postcard to the usual address. At least I learned a bit more about MySQL, so the time and effort is not completely wasted.