php phpMyAdmin 不允许我登录 - 未显示错误

phpMyAdmin won't let me login - no error shown

提问by nastaseion

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".

我在远程服务器上有 phpMyAdmin。直到今天都很好，我用了很多次（所以用户名和密码都很好）。但是，今天整个站点都不起作用，它只是说“连接太多”。

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

首先，我重新尝试重新启动 Apache 和 MySQL，但并没有解决问题。

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.

然后我用 重新启动它shutdown -r now，主站点现在可以工作了，但是 phpMyAdmin 仍然无法登录（并且它没有显示任何错误）。输入我的用户名和密码并按回车键后，它会显示准确的页面（没有错误），因为什么都不会发生。我可以看到地址栏中的令牌不同。

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?

我尝试从 /tmp 文件夹（通过 ftp）手动删除所有 php 会话，它有同样的问题。phpMyAdmin 本身的数据库会损坏吗？我怎样才能解决这个问题？

Thanks in advance

提前致谢

采纳答案by Zafar Malik

Possible reasons are-

可能的原因是——

a) user has been locked.

a) 用户已被锁定。

b) There are too many users more than specified.

b) 用户数量超过指定数量。

c) Your System/Ip (rights were provided to which) has been changed.

c) 您的系统/IP（已为其提供权利）已更改。

Please follow below steps-

请按照以下步骤操作-

Step1: Please server connect with root user and check if you are able to use your DB.

步骤 1：请用 root 用户连接服务器并检查您是否可以使用您的数据库。

Step2: execute below commands.

Step2：执行以下命令。

mysql> flush hosts;

mysql> 刷新主机；

Now try to connect from phpmyadmin if success then fine other wise check if you are getting any IP related error if yes then check if that ip have required permissions.

现在尝试从 phpmyadmin 连接，如果成功然后很好，否则检查您是否收到任何与 IP 相关的错误，如果是，然后检查该 IP 是否具有所需的权限。

Other Reasons may be

其他原因可能是

1. opened_files_limit crossed whatever you mentioned in your configuration file.
2. disk full.
3. too many thread opened/too many connections.
4. your login_user has been locked due to wrong password input a certain times (limit mentioned in configuration file default is 10).
5. mysql port (default is 3306) is not open on DB server from outside.
6. user does not have permissions from your system IP. etc.

1. opens_files_limit 跨越了您在配置文件中提到的任何内容。
2. 磁盘已满。
3. 打开的线程太多/连接太多。
4. 您的 login_user 因密码输入错误而被锁定了几次（配置文件中提到的限制默认为 10）。
5. mysql 端口（默认为 3306）未从外部在 DB 服务器上打开。
6. 用户没有来自您系统 IP 的权限。等等。

回答by Caperneoignis

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.

我的问题是，我使用的是 HTTP 而不是 HTTPS。我不知道为什么，我的服务器允许两个连接，但我必须在某些地方进行了更改，因此它只允许 HTTPS 连接。一旦我切换过来，该网站又开始工作了。

回答by Michiel Pater

In my case, the hard drive on the server was full.

就我而言，服务器上的硬盘驱动器已满。

In Linux, use df -hto view the available space on the hard drive and clean up unnecessary files.

在 Linux 中，用于df -h查看硬盘上的可用空间并清理不需要的文件。

回答by Jeff T

I just spend forever troubleshooting this.

我只是花了很多时间来解决这个问题。

You are missing the mcrypt extension.

您缺少 mcrypt 扩展名。

The mcrypt extension is missing. Please check your PHP configuration

缺少 mcrypt 扩展。请检查您的 PHP 配置

You can check if this is the case by forcing

您可以通过强制检查是否是这种情况

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

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

and looking at errors when you login.

并在您登录时查看错误。

回答by Bartosz Pacho?ek

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.

设备上可能没有剩余空间。在许多情况下，由于文件空间不足，不允许创建会话。

回答by Amir Khalil

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

就我而言，我试图通过 HTTP 而不是 HTTPS 进行访问。

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

一旦我将地址更改为https://mysite/phpmyadmin，我就可以访问了。

回答by Ecko

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.

我在登录时遇到了类似的问题。我通过清除 Chrome 中的浏览数据解决了这个问题。也许只需简单地重新启动 Chrome 就足够了。我注意到即使不清除浏览数据或重新启动 Chrome，我也能够以隐身模式登录。有趣的是，当我尝试手动清除站点的 cookie 时，它​​并没有解决问题。

回答by Kiran P.

Check if there is enough space available on server. In my case it was space problem. I deleted some files and its working fine now.

检查服务器上是否有足够的可用空间。就我而言，这是空间问题。我删除了一些文件，现在工作正常。

To check available space : df -h

检查可用空间： df -h

To check available inodes : df -i

要检查可用的 inode： df -i

CodeIgniter cache was taking so much space.

CodeIgniter 缓存占用了太多空间。

回答by userlond

Had the same issue.

有同样的问题。

I made a typo in my php.ini file (letter 'B' at the end of 2GB is the error):

我在 php.ini 文件中输入了一个错字（2GB 末尾的字母“B”是错误）：

post_max_size = 2GB
upload_max_filesize = 2GB

Apache started up but the php.ini file didn't load correctly. After fixing the typos and reloading Apache every thing worked ok.

Apache 已启动，但 php.ini 文件未正确加载。修正拼写错误并重新加载 Apache 后，一切正常。

回答by Munjal Mayank

If there are multiple MYSQL connection running simultaneously, PHPMYADMIN won't allow you to login (neither it'll show any error).

如果有多个 MYSQL 连接同时运行，PHPMYADMIN 将不允许您登录（也不会显示任何错误）。

Either you need to increase your max_user_connection value (you can do that via ini) or you need to wait for sometime and try.

要么您需要增加 max_user_connection 值（您可以通过 ini 执行此操作），要么您需要等待一段时间并尝试。