MySQL phpmyadmin.pma_table_uiprefs 不存在
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/20731487/
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
phpmyadmin.pma_table_uiprefs doesn't exist
提问by Markus Kottl?nder
I searched the internet but cannot find anything related to this specific error/table. It pops up when I try to view a table in phpMyAdmin. I am logged in as root and the installation (under ubuntu 13.10) of phpMyAdmin is fresh and untouched so far.
我搜索了互联网，但找不到与此特定错误/表格相关的任何内容。当我尝试在 phpMyAdmin 中查看表格时它会弹出。我以 root 身份登录，并且 phpMyAdmin 的安装（在 ubuntu 13.10 下）到目前为止是全新的且未受影响。
Here is the whole message:
这是整个消息：
SELECT `prefs`
FROM `phpmyadmin`.`pma_table_uiprefs`
WHERE `username` = 'root'
AND `db_name` = 'symfony'
AND `table_name` = 'users'
MySQL reports: #1146 - Table 'phpmyadmin.pma_table_uiprefs' doesn't exist
Is the installation just broken or am I missing something?
是安装坏了还是我遗漏了什么？
回答by Marc Delisle
You are missing at least one of the phpMyAdmin configuration storage tables, or the configured table name does not match the actual table name.
您至少缺少一个 phpMyAdmin 配置存储表，或者配置的表名与实际表名不匹配。
See http://docs.phpmyadmin.net/en/latest/setup.html#phpmyadmin-configuration-storage.
请参阅http://docs.phpmyadmin.net/en/latest/setup.html#phpmyadmin-configuration-storage。
A quick summary of what to do can be:
要做什么的快速总结可以是：
- On the shell:
locate create_tables.sql. - import
/usr/share/doc/phpmyadmin/examples/create_tables.sql.gzusing phpMyAdmin. - open
/etc/phpmyadmin/config.inc.phpand edit lines 81-92: changepma_bookmarktopma__bookmarkand so on.
- 在外壳上：
locate create_tables.sql. /usr/share/doc/phpmyadmin/examples/create_tables.sql.gz使用 phpMyAdmin导入。- 打开
/etc/phpmyadmin/config.inc.php并编辑第 81-92 行：更改pma_bookmark为pma__bookmark等等。
回答by Mikkel
I came across this same problem on Ubuntu 13.10. I didn't want to hack PHP files, because normally phpMyAdmin works out of the box after installing the package from Ubuntu repositories. Instead I ran:
我在 Ubuntu 13.10 上遇到了同样的问题。我不想破解 PHP 文件，因为通常 phpMyAdmin 在从 Ubuntu 存储库安装软件包后开箱即用。相反，我跑了：
sudo dpkg-reconfigure phpmyadmin
During reconfigure, I said "yes" to reinstalling the phpMyAdmin database. Afterwards, the problem was gone. I have a vague memory of answering "No" to that question at some earlier time, during an install or upgrade. That is probably why the problem occurred in the first place.
在重新配置期间，我对重新安装 phpMyAdmin 数据库说“是”。之后，问题就没有了。我有一个模糊的记忆，在安装或升级过程中，早些时候对这个问题回答“否”。这可能是问题首先出现的原因。
回答by iceberg
You just change following line in /etc/phpmyadmin/config.inc.php
您只需更改 /etc/phpmyadmin/config.inc.php 中的以下行
$ Cfg ['Servers'] [$ i] ['table_uiprefs'] = ‘pma_table_uiprefs';
to
到
$ cfg ['Servers'] [$ i] ['pma__table_uiprefs'] = ‘pma__table_uiprefs';
And restart apache server with command,
并使用命令重新启动apache服务器，
sudo service apache2 restart
回答by Spl2nky
Try sudo dpkg-reconfigure phpmyadmin
尝试 sudo dpkg-reconfigure phpmyadmin
To Replace config file /etc/phpmyadmin/config-db.php with new version
用新版本替换配置文件 /etc/phpmyadmin/config-db.php
回答by japetko
I had to change this rows:
我不得不改变这一行：
$cfg['Servers'][$i]['pma__bookmarktable'] = '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__history'] = 'pma__history';
$cfg['Servers'][$i]['pma__table_uiprefs'] = 'pma__table_uiprefs';
$cfg['Servers'][$i]['pma__designer_coords'] = 'pma__designer_coords';
$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__table_uiprefs'] = 'pma__table_uiprefs';
add: "pma__" to ['bookmarktable'] and "_" to 'pma_bookmark'
添加：“ pma__”到['bookmarktable'] 和“ _”到'pma_bookmark'
回答by Alireza Alallah
you should reconfigure the phpmyadmin On terminal:
您应该在终端上重新配置 phpmyadmin：
- sudo dpkg-reconfigure phpmyadmin
- 须藤 dpkg-重新配置 phpmyadmin
回答by Apurba Pathak
I found a solution to fix this.
我找到了解决此问题的解决方案。
Edit your /etc/phpmyadmin/config.inc.php file.
编辑您的 /etc/phpmyadmin/config.inc.php 文件。
Find:
找：
if (!empty($dbport) || $dbserver != 'localhost') {
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['port'] = $dbport;
}
Add after:
之后添加：
$cfg['Servers'][$i]['pmadb'] = null; // Apurba
Restart your apache service and try. Hope it helps. Thanks.
重新启动您的 apache 服务并尝试。希望能帮助到你。谢谢。
回答by user7551673
I use Windows 7 Xampp'sversion of phpmyadmin and none of the above, or below if this post gets upvoted, answers worked. I have tried uninstalling Xampp and upgrading to a higher version, manually changing values in the config folder, importing .sql files from some github page, and even viewing youtube videos but none of the suggestions worked.
我使用Windows 7 Xampp 的phpmyadmin 版本，上面没有，或者如果这篇文章被点赞，答案就行了。我尝试卸载 Xampp 并升级到更高版本，手动更改配置文件夹中的值，从某些 github 页面导入 .sql 文件，甚至查看 youtube 视频，但没有任何建议有效。
Solution:
解决方案：
Delete EVERYTHING in the C:\xampp\phpMyAdmin folder > go to https://www.phpmyadmin.net/and download the latest version > extract everything to the C:\xampp\phpMyAdmin folder and your problem is solved.
删除 C:\xampp\phpMyAdmin 文件夹中的所有内容 > 转到https://www.phpmyadmin.net/并下载最新版本 > 将所有内容解压缩到 C:\xampp\phpMyAdmin 文件夹中，您的问题就解决了。
^^^^^ Read this if you don't want to waste hours searching Google for tons of failed solutions. It's far simpler too! ^^^^^^
^^^^^ 如果您不想浪费时间在 Google 上搜索大量失败的解决方案，请阅读本文。它也简单得多！^^^^^^
回答by Adam Filipczyk
I had the same problem with latest Lampp with MariaDB on Ubuntu Server 14.04, and @iceberg's solution worked very well:
我在 Ubuntu Server 14.04 上使用 MariaDB 的最新 Lampp 遇到了同样的问题，@iceberg 的解决方案运行良好：
You just change following line in /etc/phpmyadmin/config.inc.php
$ Cfg ['Servers'] [$ i] ['table_uiprefs'] = ‘pma_table_uiprefs';to
$ cfg ['Servers'] [$ i] ['pma__table_uiprefs'] = ‘pma__table_uiprefs';And restart apache server with command,
sudo service apache2 restart
您只需更改 /etc/phpmyadmin/config.inc.php 中的以下行
$ Cfg ['Servers'] [$ i] ['table_uiprefs'] = ‘pma_table_uiprefs';到
$ cfg ['Servers'] [$ i] ['pma__table_uiprefs'] = ‘pma__table_uiprefs';并使用命令重新启动apache服务器，
sudo service apache2 restart
Lampp config.inc.phpis located in /opt/lampp/phpmyadmin/config.inc.phpand to make it work, I also needed to change
Lampp config.inc.php位于/opt/lampp/phpmyadmin/config.inc.php并使其工作，我还需要更改
$ cfg ['Servers'] [$ i] ['tracking'] = ‘pma__tracking';
to
到
$ cfg ['Servers'] [$ i] ['pma__tracking'] = ‘pma__tracking';
and restart the lampp:
并重新启动lampp：
sudo /opt/lampp/lampp stop
sudo /opt/lampp/lampp start
回答by Tell Me How
Steps:
脚步：
- Just download create_table.sql from GitHuband save that file in your system.
- Then go to your phpMyAdmin.
- And click on Import from upper tab.
- At last select create_table.sql and upload that.
- 只需从GitHub下载 create_table.sql并将该文件保存在您的系统中。
- 然后转到您的 phpMyAdmin。
- 然后单击从上方选项卡导入。
- 最后选择 create_table.sql 并上传。
After all it works for me and hopefully work for you.
毕竟它对我有用，希望对你有用。
