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

问题描述

我正在尝试使用 XAMPP 在 MySQL 中设置我的数据库.我通过本地主机上的 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)
• mySQL Ver 14.14 Distrib 5.7.9，适用于 osx10.11 (x86_64)
• 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!

推荐答案

如果有人仍然面临这个问题，对我来说，这是在我将 mysql/data 更改为 mysql 后开始发生的/backup 更早解决另一个问题.

if someone is still facing this issue, for me it started to occur after I changed my mysql/data with mysql/backup earlier to solve another issue.

我尝试了很多方法，最后发现解决方法很简单！只需在打开 PhPMyAdmin(在我的情况下正在加载)后单击这个图标(重置会话)就在 PhPMyAdmin 的徽标下方.一键解决问题！

I tried a lot of methods, and finally found the solution was very simple! Just click on this icon(Reset session) after opening PhPMyAdmin(it was loading in my case) just below the logo of PhPMyAdmin. It fixed the issue in one-click!

对我来说，错误代码是 #1142

For me, the error code was #1142

PhpMyAdmin 重置会话

PhpMyAdmin Reset Session

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