MySQL #1146 - 表 'phpmyadmin.pma_column_info' 不存在
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/25198923/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
#1146 - Table 'phpmyadmin.pma_column_info' doesn't exist
提问by Ido Daniel
I've recently just installed XAMPP and I'm pretty new to all of this. I was trying to open a new DB in phpmyadmin, but it wrote me this error - #1146 - Table 'phpmyadmin.pma_column_info' doesn't exist.
我最近刚刚安装了 XAMPP，我对这一切都很陌生。我试图在 phpmyadmin 中打开一个新数据库，但它给我写了这个错误 - #1146 - Table 'phpmyadmin.pma_column_info' doesn't exist.
I looked it up on the web and it said that I need to run a query of create_tables.sqlon the DB "phpmyadmin", but everytime I click on that database it just errors me the same error as before - #1146 - Table 'phpmyadmin.pma_column_info' doesn't exist.
我在网上查了一下，它说我需要create_tables.sql在数据库“phpmyadmin”上运行一个查询，但是每次我点击那个数据库时，它都会给我错误和以前一样的错误 - #1146 - Table 'phpmyadmin.pma_column_info' doesn't exist。
Can anyone help me with it?
任何人都可以帮助我吗？
Thanks, Dan
谢谢，丹
回答by CavanST
None of the answers above or on other posts worked.
上面或其他帖子上的答案都没有奏效。
I solved the issue by going into my file explorer and deleting the phpmyadmin directory. Then you can run create_tables.sql in phpmyadmin and it should all work from there.
我通过进入我的文件资源管理器并删除 phpmyadmin 目录解决了这个问题。然后你可以在 phpmyadmin 中运行 create_tables.sql ，它应该从那里开始工作。
phpmyadmin directory can be found in C:\xampp\mysql\data
phpmyadmin目录在C:\xampp\mysql\data
create_tables.sql is in C:\xampp\phpMyAdmin\sql
create_tables.sql 在 C:\xampp\phpMyAdmin\sql
Don't forget to restart xampp.
不要忘记重新启动xampp。
回答by Edward Torvalds
You will find create_tables.sql.gzfile in /usr/share/doc/phpmyadmin/examples/` dir
您将create_tables.sql.gz在 /usr/share/doc/phpmyadmin/examples/` 目录中找到文件
Extract it, sudo file-roller create_tables.sql.gzand change pma_prefix by pma__or vice versa
提取它，sudo file-roller create_tables.sql.gz并更改pma_前缀，pma__反之亦然
Then import you new script SQL from phpmyadmin in your browser
然后在浏览器中从 phpmyadmin 导入新的脚本 SQL
回答by optimiertes
sudo dpkg-reconfigure phpmyadmin
That's it.
就是这样。
回答by Paolo P.
This is an optional feature that require to create tables from create_tables.sql
这是一个可选功能，需要从 create_tables.sql 创建表
You can disable it just edit the file config.inc.php and comment these lines:
您可以禁用它，只需编辑文件 config.inc.php 并注释这些行：
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
$cfg['Servers'][$i]['relation'] = 'pma_relation';
$cfg['Servers'][$i]['table_info'] = 'pma_table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma_column_info';
$cfg['Servers'][$i]['history'] = 'pma_history';
$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
回答by oasisfleeting
Windows If you're using xampp since php 5.6.19 or later on initial setup you need to drop the phpmyadmin database and recreate it using the scripts in X:\xampp\phpMyAdmin\sql
Windows 如果您在初始设置时从 php 5.6.19 或更高版本开始使用 xampp，您需要删除 phpmyadmin 数据库并使用 X:\xampp\phpMyAdmin\sql 中的脚本重新创建它
