Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I'm having an issue with pma whereby after logging in (as root or the database owner), and trying to switch to a certain database, I am automatically logged out. I cannot do any actions on the database and in the page that loads immediately before I'm logged out I note that I can't see any tables in the database. The database is accessible by the cli mysql program and all records are still present.

To clarify:

Literally login works fine, I can browse ALL databases except the one of my projects. Trying to use that database causes the phpMyAdmin session to end.

Thanks!

share|improve this question
    
I'm guessing it is down to the php session. Try a different browser, or flush your cache. –  Sc0rian Jun 17 '12 at 18:10
    
Which cache are you referring to? I have rebooted the server to no avail, as well as try different browsers. –  deed02392 Jun 19 '12 at 8:46
add comment

1 Answer 1

up vote 0 down vote accepted

I appreciate the question is rather vague as apparently if PMA gets the message from MySQL the server has gone away, it logs you out, so the symptoms here aren't great.

I managed to realise that just before it logged out it actually did redirect to attempt to view the database. At which point I see an #2002 error, MySQL server went away.

So I checked the syslog for output from MySQL and noted that the 'data dictionaries for InnoDB and MySQL were out of sync' for a certain table. I used the CLI tool to drop this table (in my testing environment it wasn't a big deal). Now I can manipulate the database with PMA as expected.

The issue was probably caused due to ungraceful shutdowns.

share|improve this answer
add comment

Your Answer

 
discard

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.