My database tables suddenly vanished from phpMyAdmin after some stupid tinkering. How I resolved it.
Background:
So I working overtime with a crashing hard disk on a Mac laptop. My MySQL service on the XAMPP stack is wonky and keeps shutting down. I fix some of the restart problems and then am faced with a new issue: phpMyAdmin only shows the information_schema table.
I have once experienced this problem before. I changed the mysql data folder permissions allowing everyone to Read and Write and all my databases vanished from phpMyAdmin. So I figured a reversal of the permission tampering would be the resolution.
Resolution:
The red no-access icon should appear on the database folder icon in Mac indicating that you have done the right thing.