phpMyAdmin不允许我登录-未显示错误 [英] phpMyAdmin won't let me login - no error shown
问题描述
我在远程服务器上有phpMyAdmin.到今天为止还不错，我已经使用了很多次(因此用户名和密码都可以).但是，今天整个站点都无法正常工作，只是说连接太多".
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".
首先，我尝试重新启动Apache和MySQL，但并没有解决问题.
First I retried to restart Apache and MySQL, and it didn't fixed the problem.
然后我用shutdown -r now重新启动它，并且主站点现在可以正常工作，但是phpMyAdmin仍然无法登录(并且它不显示任何错误).输入我的用户名和密码并按Enter键后，它将显示准确的页面(没有错误)，因为什么也不会发生.我可以在地址栏中看到令牌是不同的.
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.
我尝试从/tmp文件夹中手动删除所有php会话(通过ftp)，并且存在相同的问题. 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?
预先感谢
推荐答案
可能的原因是-
a)用户已被锁定.
b)用户数超出指定的数量.
b) There are too many users more than specified.
c)您的系统/IP(已提供权利)已更改.
c) Your System/Ip (rights were provided to which) has been changed.
请按照以下步骤操作-
第一步:请服务器与root用户连接，并检查您是否能够使用数据库.
Step1: Please server connect with root user and check if you are able to use your DB.
Step2:执行以下命令.
Step2: execute below commands.
mysql>刷新主机；
mysql> flush hosts;
现在，如果成功，请尝试从phpmyadmin连接，然后再进行其他明智的检查，如果是，则获取与IP相关的错误，然后检查该IP是否具有必需的权限.
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.
其他原因可能是
- opened_files_limit超出了您在配置文件中提到的内容.
- 磁盘已满.
- 打开的线程过多/连接过多.
- 您的登录用户由于密码输入错误多次而被锁定(配置文件中提到的限制默认为10).
- 未从外部在数据库服务器上打开mysql端口(默认为3306).
- 用户没有您的系统IP的权限.等
这篇关于phpMyAdmin不允许我登录-未显示错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
