本来需要显示为日期时间的数据全部变成带超级链接的[BLOB - 8 字节]
blod-8.png

原因:PHP中没有启用php_mysqli.dll这个扩展。


实际上出现这种问题在phpMyAdmin的登录界面也会有提示:
login.png
在phpMyAdmin官方的FAQ中说明了具体原因:

1.20 I receive an error about missing mysqli and mysql extensions.

To connect to a MySQL server, PHP needs a set of MySQL functions called “MySQL extension”. This extension may be part of the PHP distribution (compiled-in), otherwise it needs to be loaded dynamically. Its name is probably mysqli.so or php_mysqli.dll. phpMyAdmin tried to load the extension but failed. Usually, the problem is solved by installing a software package called “PHP-MySQL” or something similar.

There are currently two interfaces PHP provides as MySQL extensions - mysql and mysqli. The mysqli is tried first, because it’s the best one.

简单来说,php中的两个扩展php_mysql.dllphp_mysqli.dll都能够支持使用phpMyAdmin,但相对而言php_mysqli.dll效果会更好。

解决方法:

在PHP配置文件(PHP目录下的php.ini)中,将

extension=php_mysqli.dll

前的;去掉

然后重启WEB服务器。