phpMyAdmin won't let me login - no error shown

2020-08-14 09:56发布

I have phpMyAdmin on a remote server. It was fine until today, I used it many times (so the username and password are fine). However, today the whole site did not worked, it simply said "too many connections".

First I retried to restart Apache and MySQL, and it didn't fixed the problem.

Then I rebooted it with shutdown -r now, and the main site does work now, but phpMyAdmin still won't log in (and it does not show any error). After typing my user and password and hitting enter, it shows the exact page (with no error) as nothing would have happened. I can see that the token is different in the Address bar though.

I tried removing all php sessions manually from /tmp folder (by ftp), and it has the same problem. Could the database of phpMyAdmin itself be corrupt? How can I fix this?

Thanks in advance

2楼-- · 2020-08-14 10:34

Possibly no space left on the device. In many cases it will not allow to create the session due to lack of space for the file.

3楼-- · 2020-08-14 10:36

My issue was, I was using HTTP instead of HTTPS. I don't know why, my server allows both connections, but I must have made a change some where so it only allows HTTPS connections. Once I switched over, the website started to work again.

4楼-- · 2020-08-14 10:36

In my case, it was that I was trying to access through HTTP, not HTTPS.

Once I changed the address to https://mysite/phpmyadmin I was able to access.

5楼-- · 2020-08-14 10:37

I had similar problems with login. I solved it by clearing browsing data in Chrome. Maybe just simple restarting Chrome would be enough. I noticed that I was able to login in incognito mode even without clearing browsing data or restarting Chrome. Interesting when I was trying clearing cookies for site manually it didn't solve the problem.

6楼-- · 2020-08-14 10:37

Another reason not mentioned so far:

Modifying the webserver headers such as X-Frame-Options and others can have an effect on loading any page post-login. After login, you may see the login page refresh, but notice the address bar shows index.php+hash (meaning you are actually logged in). Or, you may simply get a blank page.

Use a browser inspector to check your PMA login page for headers received - if you see something, check your webserver configuration files for header modifications. In my case X-Frame-Options was set along with others. Once I commented these out, PMA was fine..

7楼-- · 2020-08-14 10:39

I just spend forever troubleshooting this.

You are missing the mcrypt extension.

The mcrypt extension is missing. Please check your PHP configuration

You can check if this is the case by forcing

$cfg['Servers'][$i]['auth_type'] = 'http';

and looking at errors when you login.

登录 后发表回答