phpMyAdmin错误:引擎中不存在表 [英] phpMyAdmin error: Table doesn't exist in engine

问题描述

我今天在Ubuntu 14.04上安装了XAMPP.我试图在phpMyAdmin中创建一个新数据库，但收到错误

I installed XAMPP today on Ubuntu 14.04. I tried to create a new database in phpMyAdmin but received the error

#1932-表'phpmyadmin.pma__tracking'在引擎中不存在

#1932 - Table 'phpmyadmin.pma__tracking' doesn't exist in engine

所以我用Google搜索了一下，发现应该导入位于/usr/share/doc/phpmyadmin/example的create_tables.sql(如果我没记错的话，但是我找不到它，但是我确实在/opt/lampp/phpmyadmin/sql中找到了它.所以我尝试了导入它，但是我收到相同的错误.

So I Googled a bit and I saw I should import create_tables.sql located in /usr/share/doc/phpmyadmin/example (if I remember correctly, but I couldn't locate it there, but I did locate it in /opt/lampp/phpmyadmin/sql. So I tried to import it, but I receive the same error.

首先，我安装了XAMPP 5.6.14/PHP 5.6.14两次，但是没有任何变化.然后，我安装了XAMPP 5.5.30/PHP 5.5.30，但仍然没有任何更改.我还尝试过更改config.inc.php文件(然后停止XAMPP并重新启动它).

First I installed XAMPP 5.6.14 / PHP 5.6.14 twice, but no change. Then I installed XAMPP 5.5.30 / PHP 5.5.30, but still no change. I also tried changing the config.inc.php file (then I stop XAMPP and start it again).

注意:我可以看到phpmyadmin数据库，如果我对其进行扩展，我可以看到存在问题的所有表确实存在:

Note: I can see the phpmyadmin database and if I expand it I can see that all the tables that are giving problems, do exist:

我不知道为什么会这样或如何解决.谁能帮忙吗?

I have no idea why this is happening or how to solve it. Can anyone please help?

PS:我已经看到过有人问过这个问题，但是我发现的答案都没有对我有用.

PS: I have seen that this question has been asked before, but none of the answers I found worked for me.

推荐答案

由于没有一种解决方案适合我，因此我执行了以下操作:

Since none of the solutions worked for me I did the following:

1. 以root特权:sudo nautlius打开Nautilus(Linux的文件浏览器).
2. 导航到mysql目录:/opt/lampp/var/mysql.
3. 删除phpmyadmin文件夹.这是phpMyAdmin中的phpmyadmin数据库
4. 将create_tables.sql(位于/opt/lampp/phpmyadmin/sql中找到)文件的内容复制到桌面上名为sql.sql
的另一个文件中
5. 打开MySQL命令行界面:/opt/lampp/bin/mysql -uroot -p
6. 然后在mysql提示符中运行脚本以使用source /home/user/Desktop/sql.sql
创建数据库phpmyadmin

1. Open Nautilus (Linux's file explorer) with root privileges: sudo nautlius.
2. Navigate to the mysql directory: /opt/lampp/var/mysql.
3. Delete the phpmyadmin folder. This is the phpmyadmin database in phpMyAdmin
4. Copy the content of the create_tables.sql (found at /opt/lampp/phpmyadmin/sql) file to another one on the desktop called sql.sql
5. Open the MySQL command line interface: /opt/lampp/bin/mysql -uroot -p
6. Then in the mysql promp I ran the script to create the database phpmyadmin with source /home/user/Desktop/sql.sql

那为我解决了这个问题.

That solved the problem for me.

这篇关于phpMyAdmin错误:引擎中不存在表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！