Error on phpMyAdmin after creating two tables with the same name, different case

Symptoms

When there are two tables with the same name, but different casing (e.g. lowercase vs UPPERCASE vs camelCase), the following can occur:

phpMyAdmin throws a 502 error whenever there is a UI that displays both tables

phpMyAdmin throws a 502 error when trying to drop either table

Cause

Action

To fix the issue, run the following commands in phpMyAdmin:

RENAME TABLE `MY_TABLE` TO `MY_TABLE_KEEP_ME`;
RENAME TABLE `my_table` TO `my_table_drop_me`;
RENAME TABLE `MY_TABLE_KEEP_ME` TO `MY_TABLE`;
DROP TABLE `my_table_drop_me`