Is there are a method to control where MySQL/MariaDB can access database names and table names in upper or lower cases?
There is a MySQL/MariaDB option called "lower_case_table_names" with three values that is useable for case sensitivity.
If you wish to know what the current value is for the setting, you can find out by running the following command via SSH as 'root':
mysqladmin variables | grep -i lower_case_table_names
The option must be set when MySQL/MariaDB starts. Changing the value while the server is running is not possible.
To change the value, you would need to modify the configuration file. The configuration file is normally located on the filesystem here:
The "lower_case_table_names" option will need to be under the following section:
The "0" value means database and tables names ARE case sensitive. (default on Unix-based systems):