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

问题描述

我正在尝试使用 XAMPP 在 MySQL 中设置我的数据库.我是通过 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 之外)
• 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 更改我的 mysql/data 后它开始发生/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屋！