phpMyAdmin不显示肯定具有表的数据库的表列表 [英] phpMyAdmin doesn't show table list for database that definitely has tables

问题描述

我有一个使用MySQL数据库以php编写的网站.购买新的笔记本电脑(Windows 7)后，我下载了WAMP 2.2，MySQL 5.5.20，PHP 5.3.10和phpMyAdmin 3.4.10.1.我从实时网站中导出了整个数据库，并使用MySQL控制台将其导入了我的Wamp环境.

I have a website, written in php, using a MySQL database. After buying a new laptop (Windows 7), I downloaded WAMP 2.2, with MySQL 5.5.20, PHP 5.3.10 and phpMyAdmin 3.4.10.1. I exported the whole database from the live website and imported it into my wamp environment, using MySQL console.

phpMyAdmin列出了数据库，但是说其中没有表.但是，这些网站可以在WAMP环境中工作.此外，如果我在phpMyAdmin中执行SQL"SHOW TABLES"，它将显示这些表.

phpMyAdmin lists the database, but says there are no tables in it. Yet, the websites workss within the WAMP environment. Further, if I perform an SQL "SHOW TABLES" within phpMyAdmin, it displays the tables.

对于这些表为何未在phpMyAdmin的最左列中列出，我完全感到困惑.

I'm completely puzzled as to why these tables aren't listed in the leftmost column of phpMyAdmin.

推荐答案

我遇到了类似的问题.通过一些挖掘，我发现phpMyAdmin的表列表在此查询上失败:

I was having a similar problem. Through some digging I found that phpMyAdmin's table list was failing on this query:

SHOW TABLE STATUS FROM `database`;

这是错误消息:

ERROR 1143 (42000): SELECT command denied to user ''@'localhost'
 for column `column` in table `table`

这使我想到了这样一个问题: mysql忘记了谁登录:用户"@'％'

Which led me to this SO question: mysql forgets who is logged in: command denied to user ''@'%'

这促使我得出以下结论:我加载到数据库中的视图之一具有特权冲突.确实，当我查看从中加载数据库的SQL转储时，我发现了罪魁祸首:

Which led me to the conclusion that one of the views that I loaded into the database has privileges that are conflicting. Indeed, when I looked at the SQL dump I was loading the database from, I found the culprit:

CREATE ALGORITHM=UNDEFINED DEFINER=`someotheruser`@`localhost` ..

本地MySQL中不存在someotheruser的位置.我将其更改为以下内容:

Where someotheruser did not exist in my local MySQL. I changed it to the following:

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` ..

然后重新加载视图，一切都可以正常工作了.

And reloaded the view, and everything is now working properly.

这篇关于phpMyAdmin不显示肯定具有表的数据库的表列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！