Can't drop tables in phpMyAdmin because they are not visible in structure
I have a local development environment with MAMP. In this environment, I am using MySQL at version 5.6.35.
When I now want to import a database from phpMyAdmin, I get an internal server error every time I try.
After some research, I think there is a problem with the structure of the mysql database.
I encountered the following error in the logs:
InnoDB: Error: Table "mysql". "innodb_table_stats" was not found.
And a hint to this page: https://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html
There is also a link to the solution: mysql error: "mysql" table. "innodb_table_stats" not found
My problem is that I cannot delete from mysql tables (innodb_index_stats, innodb_table_stats, slave_master_info, slave_relay_log_info, slave_worker_info). They appear in the sidebar, but not in the structure itself.
And if I click on them I get more errors:
What I could have done and have already done is remove the .frm and .ibd files from the tables above. But it had no effect.
Is there a way to restore or replace mysql db?
I also tried the replacement and update tools from MAMP. No success.
source to share