Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

When I log into phpmyadmin, it only shows the information_schema. I have only one table that has been showing perfectly, but one day it decided not to show up. My website reads all the information in the database just fine, I just can't see it in phpmyadmin. Once I restarted the mysql server and it popped back up. Now when I try to restart it, it doesn't show anymore. How can I solve this??

share|improve this question
Have you checked for permissions issues ? Do you have some views defined by a user that does not exist anymore ? – krisFR Mar 29 '14 at 21:25
When I look for my database I can't even see it, so can't add permissions to it. It was working fine when I logged off one day, and when I came back it had disappeared. – Charles Mar 31 '14 at 4:34
up vote 0 down vote accepted

The most likely explanation would be that you are no longer logging in as a valid user through phpMyAdmin. From the phpMyAdmin main page, look to the right side; under "Database server" it should tell you what username you're connected as.

Try connecting from the command line client with mysql -u root -p or whatever username you have instead of root. See if you can show other databases from there.

share|improve this answer
Thank you! For some reason it was logging in as what looked like a temporary user instead of my username – Charles Apr 2 '14 at 3:47

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.