# 1146 -表的phpmyadmin。pma_recent”根本不存在

Solution Guys...

解决方案的家伙……

FYI i am using xampp to use phpmyadmin. and this error happens during the process of creating a database on localhost. Below is the code for config.inc file under phpmyadmin directory:

我正在使用xampp来使用phpmyadmin。此错误发生在在本地主机上创建数据库的过程中。下面是配置的代码。phpmyadmin目录下的inc文件:

<?php
/*
 * This is needed for cookie based authentication to encrypt password in
 * cookie
 */
$cfg['blowfish_secret'] = 'xampp'; /* YOU SHOULD CHANGE THIS FOR A MORE SECURE COOKIE      AUTH! */

/*
 * Servers configuration
 */
$i = 0;

/*
 * First server
 */
$i++;

/* Authentication type and info */
$cfg['Servers'][$i]['auth_type'] = 'HTTP';
$cfg['Servers'][$i]['user'] = 'root'; 
$cfg['Servers'][$i]['password'] = 'password';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
$cfg['Lang'] = '';

/* Bind to the localhost ipv4 address and tcp */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';

/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = '';

/* Advanced phpMyAdmin features */
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
$cfg['Servers'][$i]['relation'] = 'pma_relation';
$cfg['Servers'][$i]['table_info'] = 'pma_table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma_column_info';
$cfg['Servers'][$i]['history'] = 'pma_history';
$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
//$cfg['Servers'][$i]['tracking'] = 'pma_tracking';
//$cfg['Servers'][$i]['userconfig'] = 'pma_userconfig';
//$cfg['Servers'][$i]['recent'] = 'pma_recent';
//$cfg['Servers'][$i]['table_uiprefs'] = 'pma_table_uiprefs';

/*
 * End of servers configuration
 */

?>

15 个解决方案

#1

You have to run the create_tables.sql inside the examples/ folder on phpMyAdmin to create the tables needed for the advanced features. That or disable those features by commenting them on the config file.

您必须运行create_tables。phpMyAdmin中的示例/文件夹中的sql创建高级功能所需的表。通过在配置文件上注释这些特性或禁用这些特性。

#2

i've resolved with

我已经解决了

sudo dpkg-reconfigure phpmyadmin

#3

"You have to run the create_tables.sql inside the examples/ folder on phpMyAdmin to create the tables needed for the advanced features. That or disable those features by commenting them on the config file".

“您必须运行create_tables。phpMyAdmin中的示例/文件夹中的sql创建高级功能所需的表。通过在配置文件上注释这些特性或禁用这些特性。

/usr/share/doc/phpmyadmin/examples/

Only to complete de choosed answer, this is the path to the examples/ directory on Ubuntu.

只有完全的选择答案，这是在Ubuntu上的例子/目录的路径。

Just use the import feature and choose "create_tables.sql.gz".

只需使用导入功能并选择“create_tables.sql.gz”。

#4

I encountered the same problem but none of your answers solved it. But I found this link. I had to edit /etc/phpmyadmin/config.inc.php:

我遇到了同样的问题，但没有一个答案能解决它。但是我找到了这个链接。我必须编辑/etc/phpmyadmin/config.inc.php:

$cfg['Servers'][$i]['table_uiprefs'] = 'pma_table_uiprefs';

into

成

$cfg['Servers'][$i]['pma__table_uiprefs'] = ‘pma__table_uiprefs’;

My problem was solved, hope it can help others.

我的问题解决了，希望它能帮助别人。

#5

You will find create_tables.sql.gz file in /usr/share/doc/phpmyadmin/examples/ dir

你会发现create_tables.sql。gz文件在/usr/ share/doc/phpmyadmin/examples/dir。

Extract it and change pma_ prefix by pma__ or vice versa

通过pma__提取并更改pma_前缀，反之亦然。

Then import you new script SQL :

然后导入新的脚本SQL:

#6

Just to complete the answer - on Ubuntu/Mint you can just run:

为了完成答案——在Ubuntu/Mint上，你可以运行:

zcat /usr/share/doc/phpmyadmin/examples/create_tables.sql.gz | mysql

(of course this assumes development environment where your default mysql user is root and you use no password; in other case use | mysql -uuser_name -p)

(当然，这是假定您的默认mysql用户是root用户，并且不使用密码的开发环境;在其他情况下使用| mysql -uuser_name -p)

#7

After I downloaded phpmyadmin from their website, I extracted the create_tables.sql file from the examples folder and then I imported it from the 'Import' tab of phpmyadmin.
It creates the database 'phpmyadmin' and the relevant table within.

在我从他们的网站下载了phpmyadmin之后，我提取了create_tables。来自示例文件夹的sql文件，然后我从phpmyadmin的“导入”选项卡中导入它。它创建数据库的phpmyadmin和相关的表。

This step might not be needed as the 12 tables were already there...
The problem seemed to be the double underscore in the tables' names.

这一步可能不需要，因为已经有12个表了……问题似乎是表名的双重下划线。

I edited 'config.inc.php' and added another underscore (__) after the 'pma_' prefix of the tables.

我编辑”config.inc。在表的“pma_”前缀之后添加另一个下划线(__)。

ie.

ie。

$cfg['Servers'][$i]['userconfig'] = 'pma_userconfig';

became

成为

$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';

This solved the issue for me.

这解决了我的问题。

#8

I shear the point made by user2237829. The table names in the create_tables script used a double underscore while the table names in the xampp example uses a single underscore.

我剪切了user2237829所做的点。create_tables脚本中的表名使用了双下划线，而xampp示例中的表名使用了一个下划线。

#9

This one just worked for me....

这个工作我....

The error message displayed is:

显示的错误消息为:

“# 1146 – Table ‘phpmyadmin.pma_table_uiprefs’ doesn’t exist“

on your programme files,locate the configuration file config.inc.php phpmyadmin

在您的程序文件中，定位配置文件config.inc。php phpmyadmin

Then trace the file $Cfg ['Servers'] [$ i] ['table_uiprefs'] = ‘pma_table_uiprefs’;

然后跟踪文件$Cfg ['Servers'] [$ i] ['table_uiprefs'] = ' pma_table_uiprefs ';

and replace it to the code : $cfg ['Servers'] [$ i] ['pma__table_uiprefs'] = ‘pma__table_uiprefs’;

并将其替换为代码:$cfg ['Servers'] [$ i] ['pma__table_uiprefs'] = 'pma__table_uiprefs';

restart your XAMMP and start localhost

重新启动XAMMP并启动localhost。

solved.

解决了。

#10

This is a known bug on Linux Debian. I solved using the create_tables.sql in the official package and changing pma_ with pma__ inside /etc/phpmyadmin/config.inc.php

这是Linux Debian上的一个已知bug。我使用create_tables解决了这个问题。在官方包中的sql，并在/etc/phpmyadmin/config.inc.php中使用pma__更改pma_。

#11

I also have same problem.. I tried everything solution in google, but still error.

我也有同样的问题。我尝试了谷歌的所有解决方案，但仍然是错误的。

But, now i resolved it.

但是，现在我解决了。

I've resolved with make give double slash like that:

我已经用make给出了双斜线:

//$cfg['Servers'][1]['table_uiprefs'] = 'pma__table_uiprefs';

It works!!

它的工作原理!

#12

I commented out the line with the following setting

我用下面的设置注释掉了这一行。

$cfg['Servers'][1]['table_uiprefs'] 

Its not really an elegant solution, but it worked for my needs. (Just getting a basic PMA for running queries etc without UI customization).

它并不是一个优雅的解决方案，但它能满足我的需要。(只需要获得一个基本的PMA，用于运行查询等，无需UI定制)。

Please do this only if you do not care about UI Prefs. If not, other people have answered this question very well.

如果您不关心UI Prefs，请这样做。如果没有，其他的人回答这个问题很好。

#13

Edit:

编辑:

$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig'; 

Change into:

改变为:

$Cfg ['Servers'] [$ i] ['table_uiprefs'] = ‘pma_table_uiprefs’;

Then https://kamalkaur188.wordpress.com/category/removing-error-1146-table-phpmyadmin-pma_recent-doesnt-exist/ work for me.

然后，https://kamalkaur1888.wordpress.com/category/removing-error -1146-table phpmyadmin-pma_recent-do - /为我工作。

#14

Run

运行

sudo dpkg-reconfigure phpmyadmin

in your unix/linux/Mac console

在unix / linux / Mac控制台

#15

You can also find create_tables.sql file it phpMyAdmin's repo. Just import it from phpMyAdmin panel. It should work.

您还可以找到create_tables。sql文件它phpMyAdmin的repo。从phpMyAdmin面板导入它。它应该工作。