MySQL #1146 - 表 'phpmyadmin.pma__tracking' 不存在如何手动禁用？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/28543851/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
#1146 - Table 'phpmyadmin.pma__tracking' doesn't exist how to disable manually?
提问by Crafty Mc
I received this error today in phpMyAdmin,
我今天在 phpMyAdmin 中收到此错误，
#1146 - Table 'phpmyadmin.pma__tracking' doesn't exist
nginx/1.6.2 | Database client version: libmysql - 5.5.41-MariaDB | PHP extension: mysqli
#1146 - 表 'phpmyadmin.pma__tracking' 不存在
nginx/1.6.2 | 数据库客户端版本：libmysql - 5.5.41-MariaDB | PHP 扩展名：mysqli
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.
它使它无法访问，因为每当我尝试使用 SQL 查询创建表时，我都会遇到同样的错误，#1146 - 表 'phpmyadmin.pma__tracking' 不存在。
I can't select a database or do anything in phpMyAdmin, is there a way to delete the tables manually or a workaround?
我无法在 phpMyAdmin 中选择数据库或执行任何操作，有没有办法手动删除表或解决方法？
Using any SQL i.e DROP DATABASE results in, #1146 - Table 'phpmyadmin.pma__tracking' doesn't exist.
使用任何 SQL，即 DROP DATABASE 结果，#1146 - 表 'phpmyadmin.pma__tracking' 不存在。
回答by Isaac Bennetch
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 对此进行了测试，即使我手动删除了表并收到错误消息，我也可以通过注销并重新登录来清除它。所以我的第一个建议是确保你的 phpMyAdmin 是最新的，因为这个功能在最近的版本中得到了一些改进。
Next, I suggest you log out, clear your browser cache (at least as it relates to the phpMyAdmin page), and log in again.
接下来，我建议您退出，清除浏览器缓存（至少与 phpMyAdmin 页面相关），然后重新登录。
You can either fix the table or disable that feature.
您可以修复表格或禁用该功能。
Repairing the phpMyAdmin Configuration Storage
修复phpMyAdmin 配置存储
Simply run the create_tables.sqlfile included in the examplesor sqlfolder of your phpMyAdmin installation. You should edit the file if you wish to use a non-default database name or table names.
只需运行phpMyAdmin 安装create_tables.sql的examples或sql文件夹中包含的文件。如果您希望使用非默认数据库名称或表名称，则应编辑该文件。
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 mysqlcommand 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.
如果出于某种原因，您的 phpMyAdmin 仍然不允许您登录，这可能会更加困难。在这种情况下，您可以mysql从命令行客户端执行此操作或禁用该功能（见下文）以获得访问权限。不过，这不应该是必要的。如果表丢失，phpMyAdmin 应该在登录时自动禁用该功能。
Then edit config.inc.phpand 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_pmadbfor the list if you have any question about the default values.
然后编辑config.inc.php并确保为每个表分配的值与您刚刚创建的表名称相对应。如果您对默认值有任何疑问，请参阅http://docs.phpmyadmin.net/en/latest/config.html#cfg_Servers_pmadb以获取列表。
Disabling the feature outright
彻底禁用该功能
Simply edit config.inc.phpand remove the line $cfg['Servers'][$i]['tracking']. This will disable the feature entirely so that phpMyAdmin doesn't look for the tracking table.
只需编辑config.inc.php并删除该行$cfg['Servers'][$i]['tracking']。这将完全禁用该功能，以便 phpMyAdmin 不查找跟踪表。
