MySQL tables do not appear on phpMyAdmin (XAMPP MAC)

Posted by admin at July 17, 2018

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:

  1. Open the folder preferences for the database folders in /Applications/XAMPP/xamppfiles/var/mysql
  2. Right Click on the database folder and click on “Get Info”
  3. Scroll to the bottom “Privileges”. Make sure that there are 2 users in the box.
    1. “_mysql” set preferences to : Read & Write
    2. “everyone” set preferences to : No Access

    The red no-access icon should appear on the database folder icon in Mac indicating that you have done the right thing.

  4. Open phpMyAdmin and the database should be available in the list.
   0 likes

Suggested Read