'PhpMyAdmin keeps redirecting to login screen
I'm having troubles logging in to PhpMyAdmin. When I press "login" after typing in my credentials, it just keeps going back to the login screen. I could login perfectly a few days ago. I don't know what I've done that's causing this.
I can login to mysql perfectly in the shell (mysql -D database -u user -ppassword). My sites are running as expected. What could this be?
Edit: logging in works fine in Firefox, but not in Chrome or IE See reply #4 in this topic: https://sourceforge.net/projects/phpmyadmin/forums/forum/72909/topic/4479151
Thx.
Solution 1:[1]
After googling this issue for ages I finally figured out what it was in my case. The problem was that google chrome does a validity check against the timestamp of the cookie (or something like this). Simply make sure that the server with PMA installed on it has the correct date/time settings and isn't out of sync. This should fix your problem.
Solution 2:[2]
If all your configurations for phpMyAdmin are correct but the problem still persists, it could be due lack of disk space. If this is the case, you can use df -h to diagnose the space problem.
My scenario was that a cron was used to create mysqldump of a large database until the space ran out. After deleting the sql dumps, phpMyAdmin logged in as it should.
Hope it helps.
Solution 3:[3]
This occurred when i switched to HTTPS, so just check that, could also be the issue.
Solution 4:[4]
I had same issue with phpmyadmin works fine in Firefox, IE but not Chrome. Clearing any cookies related to phpmyadmin (phpmyadmin or starting with "pma") solved it.
Solution 5:[5]
This problem can occur as well if the directories opcache, session and wsdlcache in /var/lib/php don't have sufficient permissions
We had to change the group ownership from apache to nginx
sudo -R chown root:nginx /var/lib/php
After changing the permissions we could login with phpmyadmin
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | YoriKv |
| Solution 2 | sagunms |
| Solution 3 | Strauss Bornman |
| Solution 4 | Pham Le Loi |
| Solution 5 | Computerdoc |
