MySQL phpmyadmin 显示空白页面

Phpmyadmin shows blank page

提问by Swapnil Shukla

Recently we have upgraded our mysql from 5.5.x to 5.6.x in an Ubuntu 12.04, also we have changed php5-mysql library with php5-mysqlnd(Which is recommended from MySql).

最近我们在 Ubuntu 12.04 中将 mysql 从 5.5.x 升级到 5.6.x，我们还使用 php5-mysqlnd 更改了 php5-mysql 库（从 MySql 推荐）。

Since our change in library phpmyadmin stopped working and shows a blank page.

由于我们在库 phpmyadmin 中的更改停止工作并显示一个空白页面。

I have followed so many forum and advises from forum contributor but have not had success so far.

我关注了很多论坛并从论坛贡献者那里得到建议，但到目前为止还没有成功。

I also used ubuntu repository as suggested in this other topic at stackoverflowppa:nijel which I believe has the modified phpmyadmin package and include the support of php5-mysqlnd, but still no success.

我还使用了 ubuntu 存储库，如stackoverflowppa:nijel 上的另一个主题中所建议的那样，我认为它具有修改后的 phpmyadmin 包并包含对 php5-mysqlnd 的支持，但仍然没有成功。

I also have enabled highest verbosity on the php.ini but still nor error or warning is generating in any log, using chrome developer tools it shows "500 Internal Server Error".

我还在 php.ini 上启用了最高详细级别，但仍然没有在任何日志中生成错误或警告，使用 Chrome 开发人员工具显示“500 内部服务器错误”。

I am clueless now, if anyone can help me to determine what I may be missing obvious.

我现在一无所知，如果有人可以帮助我确定我可能明显遗漏了什么。

回答by Matty

In case someone (like I was) is using phpmyadmin via xampp on windows and has skype turned on - try turning skype off (or configure xampp to use another port).

如果有人（像我一样）在 Windows 上通过 xampp 使用 phpmyadmin 并且打开了 Skype - 尝试关闭 Skype（或配置 xampp 以使用另一个端口）。

回答by Vibhas

Check Mysql & Php error log files located at /var/log/mysql/error.log and /var/log/apache2/error.log respectively

检查分别位于 /var/log/mysql/error.log 和 /var/log/apache2/error.log 的 Mysql 和 Php 错误日志文件

回答by Swapnil Shukla

Even after multiple uninstall, purge and reinstall of phpmyadmin I did not get a success.

即使在多次卸载、清除并重新安装 phpmyadmin 之后，我也没有成功。

Finally I used bruit-force approach and from another Linux server where phpmyadmin was running properly I copied all i.e. /usr/share/phpmyadmin, /etc/phpmyadmin and /var/lib/phpmyadmin folders and over write them in the problematic server.

最后，我使用了暴力方法，并从另一个 phpmyadmin 正常运行的 Linux 服务器复制了所有 ie /usr/share/phpmyadmin、/etc/phpmyadmin 和 /var/lib/phpmyadmin 文件夹，并将它们覆盖在有问题的服务器中。

Every thing works perfectly now.

现在每件事都完美无缺。

Thanks for help Vibhas... I just thuoght to post just for someone's help.

感谢您的帮助 Vibhas...我只是为了某人的帮助而发帖。

回答by RespectMyAuthoritay

I was facing a similar issue with phpmyadmin (phpmyadmin was returning a blank page). It was alright once I reinstalled phpmyadmin using:

我遇到了与 phpmyadmin 类似的问题（phpmyadmin 返回了一个空白页面）。一旦我使用以下命令重新安装了 phpmyadmin 就可以了：

apt-get install --reinstall phpmyadmin

If you are not root:

如果您不是 root：

sudo apt-get install --reinstall phpmyadmin

回答by Oeldin

I just ran into a very similar error and I thought I would leave my solution here in case anyone finds this searching for my error. The difference was, that phpMyAdmin showed a blank page after a successful login.

我刚刚遇到了一个非常相似的错误，我想我会把我的解决方案留在这里，以防有人发现这个搜索我的错误。不同的是，phpMyAdmin 在成功登录后显示一个空白页面。

The solution was, removing the "X-Frame-Options: Deny" header.

解决方案是删除“X-Frame-Options: Deny”标头。

When setting up the webserver, I didn't remember that phpMyAdmin would rely on iFrames to serve its interface.

在设置网络服务器时，我不记得 phpMyAdmin 会依赖 iFrames 为其界面提供服务。

回答by Tim B.

When i changed this inside the config.inc.php:

当我在 config.inc.php 中更改此内容时：

$cfg['UploadDir'] = '/tmp'; $cfg['SaveDir'] = '/tmp';

$cfg['UploadDir'] = '/tmp'; $cfg['SaveDir'] = '/tmp';

to:

到：

$cfg['UploadDir'] = ''; $cfg['SaveDir'] = '';

$cfg['UploadDir'] = ''; $cfg['SaveDir'] = '';

and reloaded the page then it worked directly!

并重新加载页面然后它直接工作！

回答by Kevin Allison

This is a long shot, but it happened to me when I realised after a cPanel password reset I did not check the "Synchronize MySQL password" option. This used to be defaulted as checked in previous cPanel versions.

这是一个很长的镜头，但是当我意识到在重置 cPanel 密码后我没有选中“同步 MySQL 密码”选项时，它发生在我身上。这曾经在以前的 cPanel 版本中被默认为选中状态。

To fix all I did was reset my cPanel password again and selected the "Synchronize MySQL password" checkbox and PhpMyAdmin was back.

为了解决我所做的一切，我再次重置了我的 cPanel 密码并选中了“同步 MySQL 密码”复选框，然后 PhpMyAdmin 又回来了。

Hope this helps others, and if its causing a big issue cPanel should select this option by default again.

希望这对其他人有帮助，如果它引起了大问题，cPanel 应再次默认选择此选项。

回答by Bj?rn Ludwig

I had a similar experience after installing mysql 5.5.60 and phpmyadmin 4.2.12 and what did the trick for me was changing folder ownership for /var/lib/php/session which was the solution in another casefor getting php-scripts tu run in general. In my case user www-datais trying to execute related scripts, so I set folder permissions accordingly

在安装 mysql 5.5.60 和 phpmyadmin 4.2.12 后，我有类似的经历，对我来说，诀窍是更改 /var/lib/php/session 的文件夹所有权，这是另一种让 php-scripts 运行的解决方案一般来说。就我而言，用户www-data正在尝试执行相关脚本，因此我相应地设置了文件夹权限

chown -R www-data:www-data /var/lib/php5/

and the page appeared as expected.

并且页面按预期出现。