phpmyadmin.pma_table_uiprefs 不存在

2022-01-05 00:00:00 mysql phpmyadmin

我搜索了互联网，但找不到与此特定错误/表格相关的任何内容.当我尝试在 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. 在 shell 上:找到 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.

相关文章