MySQL错误-#1932-引擎中不存在表'phpmyadmin.pma user config' [英] MySQL error - #1932 - Table 'phpmyadmin.pma user config' doesn't exist in engine

问题描述

我正在尝试使用XAMPP在My​​SQL中设置数据库.我正在通过localhost上的phpMyAdmin执行此操作(Apache正在运行).就我而言，唯一的操作是输入一个新的未使用的数据库名称，单击创建"并....

I am trying to set up my database in MySQL using XAMPP. I am doing this via phpMyAdmin on localhost(Apache is running). The only action on my part is typing in a new, unused, name for a database, click create and...

Error
SQL query: DocumentationEdit Edit


SELECT MAX(version) FROM `phpmyadmin`.`pma__tracking` WHERE `db_name` = 'stuff_tessss'  AND `table_name` = ''  AND FIND_IN_SET('CREATE DATABASE',tracking) > 0
MySQL said: Documentation

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

数据库显示在数据库列表中.如果您单击一个，则可能需要一整天和一天的时间才能加载.

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

The database is showing in the list of databases. If you were to click on one, it takes forever and a day to not load.

我曾尝试在堆栈和其他地方研究和实现其他1932年错误解决方案，但无济于事.

I've tried researching and implementing the other 1932 error solutions on stack and other places but to no avail.

以下是我正在使用的技术的以下版本:

Here are the following versions for the tech I am utilizing:

• OS X El Capitan-10.11.1
• 服务器版本:Apache/2.4.16(Unix)
• PHP 5.6.15(我必须使用-intl扩展名重新安装，因为CakePHP抱怨存在依赖性)
• CakePHP 3.0(这是必须安装Composer才能从命令行使用cakePHP，我认为它是在PHP之上运行的)
• 用于osx10.11(x86_64)的mySQL Ver 14.14 Distrib 5.7.9
• XAMPP 5.6.14-4

我已经阅读了各种解决方案，例如在Linux上运行它或使用较旧版本的XAMPP等.我发现那里有一个更聪明的人，他可能知道该解决方案.我主要也很难尝试去研究哪里.

I've read all sorts of solutions such as run it in Linux, or using an older version of XAMPP, etc. I figured there is a smarter person out there who might know the solution. I mainly had a hard time trying to figure out where to research, as well.

如果有人能指出我正确的方向，我将不胜感激！

If anyone who could point me in the right direction I would greatly appreciate it!

推荐答案

最后，我找到了解决方案.
扩展phpmyadmin数据库时，我们发现表'pma__tracking'确实存在.

但是#1932上的系统错误调用-表'phpmyadmin.pma__tracking'在引擎中不存在.

因此，只需尝试先删除旧的pma __ *数据库，然后再重新配置它们即可.

1.删​​除xampp安装路径中的错误表并删除var/mysql/phpmyadmin/中的所有文件，类似于pma__bookmark.frm/pma__bookmark.ibd ...

2.重新安装位于phpmyadmin/sql/中的phpmyadmin的sql，类似于"create_tables.sql"，并使用mysql< create_table.sql等.

然后就可以了.

Finally, I find the solution.
We can find there really exists the table 'pma__tracking' when we expand the phpmyadmin database.

But the system error call on #1932 - Table 'phpmyadmin.pma__tracking' doesn't exist in engine.

So just try to remove the old pma__* database first and reconfig them later.

1.Remove the wrong tables in xampp's installation path and remove all the files in var/mysql/phpmyadmin/, which are similar like pma__bookmark.frm/pma__bookmark.ibd...

2.Reinstall the sql of phpmyadmin, which located in phpmyadmin/sql/, something like 'create_tables.sql', run them with mysql < create_table.sql, etc.

Then it works.

这篇关于MySQL错误-#1932-引擎中不存在表'phpmyadmin.pma user config'的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！