MySQL 错误 - #1932 - 引擎中不存在表“phpmyadmin.pma 用户配置”

Question

提问by smoke

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...

我正在尝试使用 XAMPP 在 MySQL 中设置我的数据库。我是通过 localhost 上的 phpMyAdmin 执行此操作的（Apache 正在运行）。我唯一的操作是为数据库输入一个新的、未使用的名称，单击创建并...

this error occurs:

发生此错误：

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 - Table 'phpmyadmin.pma__tracking' doesn't exist in engine

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

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.

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

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

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

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

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

OS X El Capitan - 10.11.1
Server version: Apache/2.4.16 (Unix)
PHP 5.6.15 (i had to reinstall with -intl extensions because CakePHP was complaining about a dependency)
CakePHP 3.0 (this required installation of Composer to utilize cakePHP from command line, which I believe runs off of PHP)
mySQL Ver 14.14 Distrib 5.7.9, for osx10.11 (x86_64)
XAMPP 5.6.14-4

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

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.

我已经阅读了各种解决方案，例如在 Linux 中运行它，或使用旧版本的 XAMPP 等。我认为有一个更聪明的人可能知道该解决方案。我也很难弄清楚在哪里研究。

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

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

Answer 1

回答by Albert.Zhang

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.

最后，我找到了解决方案。
当我们展开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 等运行它们。

然后它就可以工作了。

Answer 2

回答by Lahiru Madusanka

I had the same error and it occured when changing the mysql/datafolder to another folder.
I just copied all folders inside mysql/datafolder to a new location except for two files. Those are ib_logfile0and ib_logfile1; those are automatically created when starting the MySQL server. That worked for me.

我有同样的错误，它发生在将mysql/data文件夹更改为另一个文件夹时。
我只是将文件mysql/data夹中的所有文件夹复制到一个新位置，除了两个文件。那些是ib_logfile0和ib_logfile1; 这些是在启动 MySQL 服务器时自动创建的。那对我有用。

Answer 3

回答by Jeem Been

In short just replace the content of config.inc.php from line 50-69 with...

简而言之，只需将第 50-69 行 config.inc.php 的内容替换为...

 $cfg['Servers'][$i]['pma__bookmark'] = 'pma__bookmark';
 $cfg['Servers'][$i]['pma__relation'] = 'pma__relation';
 $cfg['Servers'][$i]['pma__table_info'] = 'pma__table_info';
 $cfg['Servers'][$i]['pma__table_coords'] = 'pma__table_coords';
 $cfg['Servers'][$i]['pma__pdf_pages'] = 'pma__pdf_pages';
 $cfg['Servers'][$i]['pma__column_info'] = 'pma__column_info';
 $cfg['Servers'][$i]['pma__table_uiprefs'] = 'pma__history';
 $cfg['Servers'][$i]['pma__table_uiprefs'] = 'pma__table_uiprefs';
 $cfg['Servers'][$i]['pma__tracking'] = 'pma__tracking';
 $cfg['Servers'][$i]['pma__userconfig'] = 'pma__userconfig';
 $cfg['Servers'][$i]['pma__recent'] = 'pma__recent';
 $cfg['Servers'][$i]['pma__users'] = 'pma__users';
 $cfg['Servers'][$i]['pma__usergroups'] = 'pma__usergroups';
 $cfg['Servers'][$i]['pma__navigationhiding'] = 'pma__navigationhiding';
 $cfg['Servers'][$i]['pma__savedsearches'] = 'pma__savedsearches';
 $cfg['Servers'][$i]['pma__central_columns'] = 'pma__central_columns';
 $cfg['Servers'][$i]['pma__designer_coords'] = 'pma__designer_coords';
 $cfg['Servers'][$i]['pma__designer_settings'] = 'pma__designer_settings';
 $cfg['Servers'][$i]['pma__export_templates'] = 'pma__export_templates';
 $cfg['Servers'][$i]['pma__favorite'] = 'pma__favorite';

Answer 4

回答by Asghar Abbas

ErrorCode # 1932 Worked for me on Ubuntu 14.04 Trusty

ErrorCode # 1932 在 Ubuntu 14.04 Trusty 上为我工作

$cfg['Servers'][$i]['pma__bookmark'] = 'pma__bookmark';
$cfg['Servers'][$i]['pma__relation'] = 'pma__relation';
$cfg['Servers'][$i]['pma__table_info'] = 'pma__table_info';
$cfg['Servers'][$i]['pma__table_coords'] = 'pma__table_coords';
$cfg['Servers'][$i]['pma__pdf_pages'] = 'pma__pdf_pages';
$cfg['Servers'][$i]['pma__column_info'] = 'pma__column_info';
$cfg['Servers'][$i]['pma__table_uiprefs'] = 'pma__history';
$cfg['Servers'][$i]['pma__table_uiprefs'] = 'pma__table_uiprefs';
$cfg['Servers'][$i]['pma__tracking'] = 'pma__tracking';
$cfg['Servers'][$i]['pma__userconfig'] = 'pma__userconfig';
$cfg['Servers'][$i]['pma__recent'] = 'pma__recent';
$cfg['Servers'][$i]['pma__users'] = 'pma__users';
$cfg['Servers'][$i]['pma__usergroups'] = 'pma__usergroups';
$cfg['Servers'][$i]['pma__navigationhiding'] = 'pma__navigationhiding';
$cfg['Servers'][$i]['pma__savedsearches'] = 'pma__savedsearches';
$cfg['Servers'][$i]['pma__central_columns'] = 'pma__central_columns';
$cfg['Servers'][$i]['pma__designer_coords'] = 'pma__designer_coords';
$cfg['Servers'][$i]['pma__designer_settings'] = 'pma__designer_settings';   
$cfg['Servers'][$i]['pma__export_templates'] = 'pma__export_templates';
$cfg['Servers'][$i]['pma__favorite'] = 'pma__favorite';

Answer 5

回答by A.N

This is my experience for this problem maybe it could help you :

这是我对这个问题的经验，也许它可以帮助你：

I copied all folders and filesinside the /datafolder to have a backup from my db.

我复制了文件夹内的所有文件夹和文件，/data以便从我的db.

When I switched to another Computer's Xamppand I started copying all folders and filescopied before from previous phpmyadmin/datafolder.

当我切换到另一台计算机时Xampp，我开始复制之前从以前的phpmyadmin文件夹复制的所有文件夹和文件。/data

So when I was done this problem happened for me .

所以当我完成时，这个问题发生在我身上。

To solve this issue :

要解决此问题：

1 -I made a backup from /datafolder of phpmyadminby copying only only folders have same name with tables I want to make backup .

1 -我通过仅复制与我想要备份的表具有相同名称的/data文件夹来从文件夹phpmyadmin进行备份。

2 -Uninstall Xampp.

2 -卸载 Xampp。

3 -Reinstall Xampp .

3 -重新安装 Xampp。

4 -Copy all foldersKept in step 1 inside mysql/datafolder . this folders are only database tables and be careful don't touchanother file and folder or replace anything when copying.

4 -将步骤 1 中保存的所有文件夹复制到文件夹内mysql/data。此文件夹只是数据库表，复制时请注意不要触及其他文件和文件夹或替换任何内容。

Answer 6

回答by David Hackro

you need to downloadthe previous version, xampp actually present bug in its latest version.

您需要下载以前的版本，xampp 实际上在其最新版本中存在错误。

Good Luck!

祝你好运！

Answer 7

回答by S.E.

If all the solutions above don't work, try to :

如果上述所有解决方案都不起作用，请尝试：

Add $i = 1; after /* Servers configuration */

添加 $i = 1; /* 服务器配置后 */

in place of $i = 0 in your phpmyadmin config.inc.php file

代替 phpmyadmin config.inc.php 文件中的 $i = 0

Running XAMPP on local windows server, my mysql data files are not under the usual install path (C:\Xampp), but on another disk.

在本地 Windows 服务器上运行 XAMPP，我的 mysql 数据文件不在通常的安装路径 (C:\Xampp) 下，而是在另一个磁盘上。

So now I have the phpmyadmin tables with the double __ like pma__table... and $i = 1;

所以现在我有了带有双 __ 的 phpmyadmin 表，比如 pma__table... 和 $i = 1;

Answer 8

回答by Albert.Zhang

I've encountered the same problem in OSX. I've tried to replace the things like
$cfg['Servers'][$i]['usergroups'] to $cfg['Servers'][$i]['pma__usergroups'] ...

我在 OSX 中遇到了同样的问题。我试图取代像
$cfg['Servers'][$i]['usergroups'] to $cfg['Servers'][$i]['pma__usergroups'] ...

It works in safari but still fails in chrome.
But the so called 'work' in safari can get the message that the features which have been modified are not in effect at all.
However, the 'work' means that I can access the dbs listed left.
I think this problem maybe a bug in the new version of XAMPP, since the #1932 problems in google is new and boomed.
You can have a try at an older version of XAMPP instead until the bug is solved.
http://sourceforge.net/projects/xampp/files/XAMPP%20Linux/5.6.12/
Hope it can help you.

它在 safari 中有效，但在 chrome 中仍然失败。
但是safari中所谓的'work'可以得到这样的信息，即已修改的功能根本无效。
但是，“工作”意味着我可以访问左侧列出的数据库。
我认为这个问题可能是 XAMPP 新版本中的一个错误，因为 google 中的 #1932 问题是新的并且蓬勃发展。
您可以尝试使用旧版本的 XAMPP，直到问题得到解决。
http://sourceforge.net/projects/xampp/files/XAMPP%20Linux/5.6.12/
希望能帮到你。

Answer 9

回答by P type Concept

make change in changes in /opt/lampp/phpmyadmin/config.inc.php    

<?php
    /* vim: set expandtab sw=4 ts=4 sts=4: */
    /**
     * phpMyAdmin sample configuration, you can use it as base for
     * manual configuration. For easier setup you can use setup/
     *
     * All directives are explained in documentation in the doc/ folder
     * or at <http://docs.phpmyadmin.net/>.
     *
     * @package PhpMyAdmin
     */

    /**
     * This is needed for cookie based authentication to encrypt password in
     * cookie
     */
    $cfg['blowfish_secret'] = 'xampp'; /* YOU SHOULD CHANGE THIS FOR A MORE SECURE COOKIE AUTH! */

    /**
     * Servers configuration
     */
    $i = 0;

    /**
     * First server
     */
    $i++;
    /* Authentication type */
    $cfg['Servers'][$i]['auth_type'] = 'config';
    $cfg['Servers'][$i]['user'] = 'root';
    $cfg['Servers'][$i]['password'] = '';
    /* Server parameters */
    //$cfg['Servers'][$i]['host'] = 'localhost';
    //$cfg['Servers'][$i]['connect_type'] = 'tcp';
    $cfg['Servers'][$i]['compress'] = false;
    $cfg['Servers'][$i]['AllowNoPassword'] = true;

    /**
     * phpMyAdmin configuration storage settings.
     */

    /* User used to manipulate with storage */
    // $cfg['Servers'][$i]['controlhost'] = '';
    // $cfg['Servers'][$i]['controlport'] = '';



    $cfg['Servers'][1]['pmadb'] = 'phpmyadmin';
    $cfg['Servers'][1]['controluser'] = 'pma';
    $cfg['Servers'][1]['controlpass'] = '';

    $cfg['Servers'][1]['bookmarktable'] = 'pma_bookmark';
    $cfg['Servers'][1]['relation'] = 'pma_relation';
    $cfg['Servers'][1]['userconfig'] = 'pma_userconfig';
    $cfg['Servers'][1]['table_info'] = 'pma_table_info';
    $cfg['Servers'][1]['column_info'] = 'pma_column_info';
    $cfg['Servers'][1]['history'] = 'pma_history';
    $cfg['Servers'][1]['recent'] = 'pma_recent';
    $cfg['Servers'][1]['table_uiprefs'] = 'pma_table_uiprefs';
    $cfg['Servers'][1]['tracking'] = 'pma_tracking';
    $cfg['Servers'][1]['table_coords'] = 'pma_table_coords';
    $cfg['Servers'][1]['pdf_pages'] = 'pma_pdf_pages';
    $cfg['Servers'][1]['designer_coords'] = 'pma_designer_coords';



    // $cfg['Servers'][$i]['favorite'] = 'pma__favorite';
    // $cfg['Servers'][$i]['users'] = 'pma__users';
    // $cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
    // $cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
    // $cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';
    // $cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';
    // $cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';
    // $cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';
    /* Contrib / Swekey authentication */
    // $cfg['Servers'][$i]['auth_swekey_config'] = '/etc/swekey-pma.conf';

    /**
     * End of servers configuration
     */

    /**
     * Directories for saving/loading files from server
     */
    $cfg['UploadDir'] = '';
    $cfg['SaveDir'] = '';

    /**
     * Whether to display icons or text or both icons and text in table row
     * action segment. Value can be either of 'icons', 'text' or 'both'.
     * default = 'both'
     */
    //$cfg['RowActionType'] = 'icons';

    /**
     * Defines whether a user should be displayed a "show all (records)"
     * button in browse mode or not.
     * default = false
     */
    //$cfg['ShowAll'] = true;

    /**
     * Number of rows displayed when browsing a result set. If the result
     * set contains more rows, "Previous" and "Next".
     * Possible values: 25, 50, 100, 250, 500
     * default = 25
     */
    //$cfg['MaxRows'] = 50;

    /**
     * Disallow editing of binary fields
     * valid values are:
     *   false    allow editing
     *   'blob'   allow editing except for BLOB fields
     *   'noblob' disallow editing except for BLOB fields
     *   'all'    disallow editing
     * default = 'blob'
     */
    //$cfg['ProtectBinary'] = false;

    /**
     * Default language to use, if not browser-defined or user-defined
     * (you find all languages in the locale folder)
     * uncomment the desired line:
     * default = 'en'
     */
    //$cfg['DefaultLang'] = 'en';
    //$cfg['DefaultLang'] = 'de';

    /**
     * How many columns should be used for table display of a database?
     * (a value larger than 1 results in some information being hidden)
     * default = 1
     */
    //$cfg['PropertiesNumColumns'] = 2;

    /**
     * Set to true if you want DB-based query history.If false, this utilizes
     * JS-routines to display query history (lost by window close)
     *
     * This requires configuration storage enabled, see above.
     * default = false
     */
    //$cfg['QueryHistoryDB'] = true;

    /**
     * When using DB-based query history, how many entries should be kept?
     * default = 25
     */
    //$cfg['QueryHistoryMax'] = 100;

    /**
     * Whether or not to query the user before sending the error report to
     * the phpMyAdmin team when a JavaScript error occurs
     *
     * Available options
     * ('ask' | 'always' | 'never')
     * default = 'ask'
     */
    //$cfg['SendErrorReports'] = 'always';

    /**
     * You can find more configuration options in the documentation
     * in the doc/ folder or at <http://docs.phpmyadmin.net/>.
     */

Answer 10

回答by ash kim

Had the same problem in Ubuntu 14 using XAMPP. Here's what I did which worked..

在使用 XAMPP 的 Ubuntu 14 中遇到了同样的问题。这是我所做的工作..

Stop mysql if its running in xampp
vi /opt/lamp/phpmyadmin/config.inc.php (use sudo if you are not the su)

replace

$cfg['Servers'][1]['relation'] = 'pma__relation';
$cfg['Servers'][1]['userconfig'] = 'pma__userconfig';
$cfg['Servers'][1]['table_info'] = 'pma__table_info';
...

to

$cfg['Servers'][1]['pma__relation'] = 'pma__relation';
$cfg['Servers'][1]['pma__userconfig'] = 'pma__userconfig';
$cfg['Servers'][1]['pma__table_info'] = 'pma__table_info';
...

basically add pma__ prefix to the left side similar to the right.

Run mysql and access localhost/phpmyadmin and click on a db to check if it works.

如果 mysql 在 xampp 中运行，则停止它
vi /opt/lamp/phpmyadmin/config.inc.php（如果你不是su，请使用sudo）

代替

$cfg['Servers'][1]['relation'] = 'pma__relation';
$cfg['Servers'][1]['userconfig'] = 'pma__userconfig';
$cfg['Servers'][1]['table_info'] = 'pma__table_info';
...

到

$cfg['Servers'][1]['pma__relation'] = 'pma__relation';
$cfg['Servers'][1]['pma__userconfig'] = 'pma__userconfig';
$cfg['Servers'][1]['pma__table_info'] = 'pma__table_info';
...

基本上在左侧添加 pma__ 前缀，类似于右侧。

运行 mysql 并访问 localhost/phpmyadmin 并单击一个数据库以检查它是否有效。

Hope this helps.

希望这可以帮助。

MySQL 错误 - #1932 - 引擎中不存在表“phpmyadmin.pma 用户配置”

提问by smoke

this error occurs:

发生此错误：

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

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

回答by Albert.Zhang

回答by Lahiru Madusanka

回答by Jeem Been

回答by Asghar Abbas

回答by A.N

回答by David Hackro

回答by S.E.

回答by Albert.Zhang

回答by P type Concept

回答by ash kim

相关推荐

最近更新

标签

MySQL 错误 - #1932 - 引擎中不存在表“phpmyadmin.pma 用户配置”

提问by smoke

this error occurs:

发生此错误：

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

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

回答by Albert.Zhang

回答by Lahiru Madusanka

回答by Jeem Been

回答by Asghar Abbas

回答by A.N

回答by David Hackro

回答by S.E.

回答by Albert.Zhang

回答by P type Concept

回答by ash kim

相关推荐

MySQL 如何在mysql中插入utf-8 mb4字符（ios5中的表情符号）？

MySQL Workbench 自动增量已禁用

MySQL SQL 设置一列的值等于同一表中另一列的值

MySQL 显示查询历史的 SQL 命令

相关推荐

最近更新

标签