phpmyadmin.pma_table_uiprefs不存在 [英] phpmyadmin.pma_table_uiprefs doesn't exist

问题描述

我搜索了Internet，但是找不到与此特定错误/表格相关的任何内容.当我尝试在phpMyAdmin中查看表时，它会弹出.我已经以root用户身份登录，并且到目前为止，phpMyAdmin的安装(在ubuntu 13.10下)是最新的且未更改.

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.

这是整个消息:

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?

推荐答案

您至少缺少一个phpMyAdmin配置存储表，或者配置的表名与实际的表名不匹配.

You are missing at least one of the phpMyAdmin configuration storage tables, or the configured table name does not match the actual table name.

请参见 http://docs.phpmyadmin.net/en/latest/setup. html#phpmyadmin-configuration-storage .

要做的事的简短摘要可以是:

A quick summary of what to do can be:

1. 在外壳上:locate create_tables.sql.
2. 使用phpMyAdmin导入/usr/share/doc/phpmyadmin/examples/create_tables.sql.gz.
3. 打开/etc/phpmyadmin/config.inc.php并编辑第81-92行:将pma_bookmark更改为pma__bookmark，依此类推.

1. On the shell: locate create_tables.sql.
2. import /usr/share/doc/phpmyadmin/examples/create_tables.sql.gz using phpMyAdmin.
3. open /etc/phpmyadmin/config.inc.php and edit lines 81-92: change pma_bookmark to pma__bookmark and so on.

这篇关于phpmyadmin.pma_table_uiprefs不存在的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！