blocks|key|151442|text|如果有多个MYSQL连接同时运行，PHPMYADMIN将不允许您登录(也不会显示任何错误)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|151443|你要么需要增加你的max_user_connection值(你可以通过ini来实现)，要么你需要等待一段时间再试一试。|151444|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

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

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.

blocks|key|4657791|text|设备上可能已没有剩余空间。在许多情况下，由于缺少文件空间，将不允许创建会话。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4657792|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

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.

blocks|key|4657854|text|我只是花了永远的时间来解决这个问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4657855|您缺少mcrypt扩展。|4657856|The+mcrypt+extension+is+missing.+Please+check+your+PHP+configuration|offset|length|4657857|您可以通过以下方式检查是否属于这种情况：|4657858|$cfg‘’Servers‘’auth_type‘=+'http'；|4657859|并在登录时查看错误。|4657860|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/22721630/the-mcrypt-extension-is-missing-please-check-your-php-configuration^0|0|0|0|1W|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|W|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|X|8|@]|9|@$F|Y|G|Z|1|10]]|A|$]]|$1|H|3|I|5|6|7|11|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|12|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|13|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|O|$P|$5|Q|R|S|A|$T|U]]]]

I just spend forever troubleshooting this.

You are missing the mcrypt extension.

<a href="https://stackoverflow.com/questions/22721630/the-mcrypt-extension-is-missing-please-check-your-php-configuration">The mcrypt extension is missing. Please check your PHP configuration</a>

You can check if this is the case by forcing

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

and looking at errors when you login.

blocks|key|151531|text|在我的例子中，服务器上的硬盘已满。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|151532|在Linux中，使用df+-h查看硬盘上的可用空间并清理不必要的文件。|offset|length|style|CODE|151533|entityMap^0|0|A|5|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@$D|L|E|M|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

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

In Linux, use <code>df -h</code> to view the available space on the hard drive and clean up unnecessary files.

blocks|key|4657944|text|也有同样的问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4657945|我在php.ini文件中犯了一个拼写错误(2+2GB末尾的字母'B‘是错误)：|4657946|post_max_size+=+2GB
upload_max_filesize+=+2GB|code-block|syntax|javascript|4657947|Apache启动了，但php.ini文件加载不正确。在修复了拼写错误并重新加载Apache之后，一切工作正常。|4657948|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|O|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Had the same issue.

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

<pre><code>post_max_size = 2GB
upload_max_filesize = 2GB
</code></pre>

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

blocks|key|4657960|text|检查服务器上是否有足够的可用空间。在我的例子中，这是空间问题。我删除了一些文件，现在可以正常工作了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4657961|检查可用空间：df+-h|offset|length|style|CODE|4657962|要检查可用的inode，请执行以下操作：df+-i|4657963|CodeIgniter缓存占用了太多空间。|4657964|entityMap^0|0|7|5|0|K|5|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@$D|P|E|Q|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|R|8|@$D|S|E|T|F|G]]|9|@]|A|$]]|$1|J|3|K|5|6|7|U|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|M|$]]

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 : <code>df -h</code>

To check available inodes : <code>df -i</code>

CodeIgniter cache was taking so much space.

blocks|key|151651|text|我的问题是，我使用的是HTTP而不是HTTPS。我不知道为什么，我的服务器允许这两个连接，但我必须在某些地方做了更改，所以它只允许HTTPS连接。一旦我切换到这个网站，它又开始工作了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|151652|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

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.

blocks|key|4658030|text|到目前为止还没有提到的另一个原因：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4658031|修改any服务器标头(如X-Frame-Options等)可能会影响登录后加载任何页面。登录后，您可能会看到登录页面刷新，但请注意，地址栏显示index.php%2Bhash+(表示您已实际登录)。或者，您可能只是得到一个空白页面。|offset|length|style|CODE|4658032|使用浏览器检查器来检查您的PMA登录页面是否收到了标题-如果您看到了什么，请检查您的see服务器配置文件中的标题修改。在我的例子中，X-Frame-Options是和其他人一起设置的。一旦我把这些注释掉了，PMA就没问题了。|4658033|entityMap^0|0|C|F|0|1U|F|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@$D|N|E|O|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@$D|Q|E|R|F|G]]|9|@]|A|$]]|$1|J|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|K|$]]

Another reason not mentioned so far:

Modifying the webserver headers such as <code>X-Frame-Options</code> 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 <code>X-Frame-Options</code> was set along with others. Once I commented these out, PMA was fine..

blocks|key|151829|text|sudo+htpasswd+/etc/phpmyadmin/htpasswd.setup+admin|type|unstyled|depth|inlineStyleRanges|entityRanges|data|151830|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

sudo htpasswd /etc/phpmyadmin/htpasswd.setup admin

blocks|key|151847|text|在我的例子中，我试图通过HTTP访问，而不是HTTPS。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|151848|一旦我将地址更改为https://mysite/phpmyadmin，我就可以访问了。|offset|length|151849|entityMap|0|LINK|mutability|MUTABLE|url|https://mysite/phpmyadmin^0|0|9|P|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

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

Once I changed the address to <a href="https://mysite/phpmyadmin" rel="nofollow noreferrer">https://mysite/phpmyadmin</a> I was able to access.

blocks|key|4658138|text|重定向可能会导致错误。例如，下面这行代码位于根文件夹中的.htaccess中：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4658139|#+redirect+all+index.php+to+the+folder+root
RewriteCond+%25{THE_REQUEST}+%5E.*/index\.php
RewriteRule+%5E(.*)index.php$+/$1+[R=301,L]|code-block|syntax|javascript|4658140|要解决此问题，您只需在PMA目录中创建一个.htaccess，并将以下行放入其中：|4658141|RewriteEngine+Off|4658142|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

a redirect can cause error.
for example this lines in .htaccess in root folder :

<pre><code># redirect all index.php to the folder root
RewriteCond %{THE_REQUEST} ^.*/index\.php
RewriteRule ^(.*)index.php$ /$1 [R=301,L]
</code></pre>

to solve it , you can simply create a .htaccess in PMA directory and put this line in it :

<pre><code>RewriteEngine Off
</code></pre>

blocks|key|151930|text|我也遇到过类似的登录问题。我通过清除Chrome浏览器中的浏览数据解决了这个问题。也许只需简单地重启Chrome就足够了。我注意到，即使没有清除浏览数据或重启Chrome，我也能够以匿名模式登录。有趣的是，当我尝试手动清除站点的cookie时，并没有解决这个问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|151931|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

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.

blocks|key|151976|text|我的问题是配置文件中有一个硬编码的主机ip：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|151977|$cfg['Servers'][$i]['host']|offset|length|style|CODE|151978|由于我的主机IP已更改，我开始遇到这个问题。|151979|希望这对其他人有帮助。|151980|entityMap^0|0|0|R|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@$D|P|E|Q|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|R|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|S|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|M|$]]

My issue was a hard coded host ip in the config file:

<code>$cfg['Servers'][$i]['host']</code>

Since my host IP has changed, I started having the issue.

Hope this helps someone else.

blocks|key|152018|text|这只是一个变通的工作，但它对我是有效的。当尝试连接到phpMyAdmin时，请使用本地主机IP地址，而不是单词“localhost”。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|152019|例如，键入'127.0.0.1/phpMyAdmin‘|152020|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

This is just a work around but it works for me. When trying to connect to phpMyAdmin use the local host IP address instead of the word 'localhost'.
For example type '127.0.0.1/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".

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

Then I rebooted it with <code>shutdown -r now</code>, 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

phpMyAdmin won't let me login - no error shown

数据库

服务器

MySQL

Linux

我在远程服务器上安装了phpMyAdmin。到今天为止，它还不错，我用了很多次(所以用户名和密码都没问题)。然而，今天整个网站都不工作了，它只是简单地说“太多的连接”。首先，我重试重启Apache和MySQL，但没有解决这个问题。然后我用shutdown -r now重启了它，主站点现在可以工作了，但是phpMyAdm...

问phpMyAdmin不让我登录-没有显示错误
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问phpMyAdmin不让我登录-没有显示错误EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问phpMyAdmin不让我登录-没有显示错误
EN