# 1146 - Table "phpmyadmin.pma_recent" does not exist

Question

Solution Solvers ...

FYI I am using xampp to use phpmyadmin. and this error occurs when creating the database on localhost. The following is the code for the config.inc file in the phpmyadmin directory:

<?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 */ ?> 

Answer 1

You need to run create_tables.sql in the examples / phpMyAdmin folder to create the tables needed for the advanced functions. This is to disable these features by commenting them in the configuration file.

Answer 2

I decided using

 sudo dpkg-reconfigure phpmyadmin 

Answer 3

"You need to run create_tables.sql inside the / folder examples on phpMyAdmin to create the tables needed for the advanced functions. This is to disable these functions by commenting them in the configuration file."

 /usr/share/doc/phpmyadmin/examples/ 

Only to complete the selected answer is the path to the examples / Ubuntu directory.

Just use the import function and select "create_tables.sql.gz".

Answer 4

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

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

at

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

My problem has been resolved, hope it can help others.

Answer 5

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

Extract it and change the pma_ prefix to pma__ or vice versa

Then import the new SQL script:

Answer 6

After I downloaded phpmyadmin from my site, I extracted the create_tables.sql file from the examples folder and then imported it from the Import tab of phpmyadmin.
It creates the database "phpmyadmin" and the corresponding table inside.

This step may not be necessary, since 12 tables already exist ...
The problem was double underscore in table names.

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

t

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

has become

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

This solved the problem for me.

Answer 7

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

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

(of course, this assumes a development environment where your mysql user is root by default and you do not use a password, otherwise use | mysql -uuser_name -p )

Answer 8

I am shifting the point made by user 2237829. The table names in the create_tables script used double underscores, while the table names in the xampp example use the same underscore.

Answer 9

This one just worked for me ....

The error message is displayed:

 "# 1146 – Table 'phpmyadmin.pma_table_uiprefs' doesn't exist" 

in your program files find the config.inc.php phpmyadmin configuration file

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

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

restart XAMMP and start the local host

resolved.

Answer 10

This is a known bug in Linux Debian. I decided to use create_tables.sql in the official package and change pma_ with pma__ inside / etc / phpmyadmin / config.inc.php

Answer 11

I have the same problem too .. I tried the whole solution in google, but still an error.

But now I have solved it.

I decided with make to give a double slash:

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

It works!!

Answer 12

I commented out the line with the following setting

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

This is not a very elegant solution, but it worked for my needs. (Just get a basic PMA to run queries, etc. Without customizing the user interface).

Please do this only if you do not need UF Prefs. If not, other people answered this question very well.

Answer 13

Edit:

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

Change to:

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

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

Answer 14

You can solve it in just 1 second !

just use this url:

 http://127.0.0.1/phpmyadmin/ 

instead

 http://localhost/phpmyadmin/ 

Answer 15

Run

 sudo dpkg-reconfigure phpmyadmin 

in unix / linux / mac console

Answer 16

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