#1146-表'phpmyadmin.pma__tracking'不存在如何手动禁用? [英] #1146 - Table 'phpmyadmin.pma__tracking' doesn't exist how to disable manually?

问题描述

我今天在phpMyAdmin中收到此错误，

I received this error today in phpMyAdmin,

nginx/1.6.2 | 数据库客户端版本:libmysql-5.5.41-MariaDB | PHP扩展名:mysqli

nginx/1.6.2 | Database client version: libmysql - 5.5.41-MariaDB | PHP extension: mysqli

它使它无法访问，因为每当我尝试使用SQL查询创建表时，我都会收到相同的错误，#1146-表'phpmyadmin.pma__tracking'不存在.

It's rendered it inaccessible as whenever I try to create the table using SQL query i get that same error, #1146 - Table 'phpmyadmin.pma__tracking' doesn't exist.

我无法选择数据库或在phpMyAdmin中做任何事情，有没有办法手动删除表或解决方法?

I can't select a database or do anything in phpMyAdmin, is there a way to delete the tables manually or a workaround?

使用任何SQL即DROP DATABASE会导致#1146-表'phpmyadmin.pma__tracking'不存在.

Using any SQL i.e DROP DATABASE results in, #1146 - Table 'phpmyadmin.pma__tracking' doesn't exist.

谢谢

推荐答案

我刚刚使用已安装的phpMyAdmin进行了测试，即使手动删除表并收到错误消息，也可以注销并清除它重新登录.因此，我的第一个建议是确保您的phpMyAdmin是最新的，因为此功能在最新版本中已有一些改进.

I just tested this with the phpMyAdmin I have installed and even when I deleted the table manually and got the error message, I could clear it up by logging out and logging back in again. So my first suggestion is to make sure your phpMyAdmin is rather up to date, as this feature has received some improvements in recent versions.

接下来，我建议您注销，清除浏览器缓存(至少与phpMyAdmin页面有关)，然后再次登录.

Next, I suggest you log out, clear your browser cache (at least as it relates to the phpMyAdmin page), and log in again.

您可以修复表格或禁用该功能.

You can either fix the table or disable that feature.

只需运行phpMyAdmin安装的examples或sql文件夹中包含的create_tables.sql文件.如果希望使用非默认数据库名称或表名称，则应编辑该文件.

Simply run the create_tables.sql file included in the examples or sql folder of your phpMyAdmin installation. You should edit the file if you wish to use a non-default database name or table names.

如果由于某种原因您的phpMyAdmin仍然不允许您登录，则可能会更加困难.在这种情况下，您可以从mysql命令行客户端执行此操作，或者禁用该功能(请参见下文)为了获得访问权限.不过，那不是必须的.如果缺少表，则phpMyAdmin应该在登录时自动禁用该功能.

This could be more difficult if, for some reason, your phpMyAdmin still doesn't let you log in. In that case, you can either do it from the mysql command line client or disable the feature (see below) in order to gain access. That shouldn't be necessary, though; phpMyAdmin should automatically disable the feature on login if the table is missing.

然后编辑config.inc.php，并确保为每个表分配的值与您刚创建的表名称相对应.请参见 http://docs.phpmyadmin.net/zh/latest/config.html#如果您对默认值有任何疑问，请访问cfg_Servers_pmadb .

Then edit config.inc.php and make sure the values assigned for each table correspond to the table names you just created. See http://docs.phpmyadmin.net/en/latest/config.html#cfg_Servers_pmadb for the list if you have any question about the default values.

只需编辑config.inc.php并删除行$cfg['Servers'][$i]['tracking'].这将完全禁用该功能，以使phpMyAdmin不会查找跟踪表.

Simply edit config.inc.php and remove the line $cfg['Servers'][$i]['tracking']. This will disable the feature entirely so that phpMyAdmin doesn't look for the tracking table.

这篇关于#1146-表'phpmyadmin.pma__tracking'不存在如何手动禁用?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！