Best IT Recipes

Phpmyadmin.pma_table_uiprefs does not exist

I searched on the internet but cannot find anything related to this particular error / table. It appears when I try to view a table in phpMyAdmin. I am registered as root and the installation (under ubuntu 13.10) phpMyAdmin is fresh and untouched so far.

Here is the 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?

+56
mysql phpmyadmin
Dec 22 '13 at 16:26
source share
20 answers

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

See http://docs.phpmyadmin.net/en/latest/setup.html#phpmyadmin-configuration-storage .

A brief description of what to do may be:

  • In the shell: locate create_tables.sql .
  • import /usr/share/doc/phpmyadmin/examples/create_tables.sql.gz using phpMyAdmin.
  • open /etc/phpmyadmin/config.inc.php and edit lines 81-92: change pma_bookmark to pma__bookmark , etc.
+121
Dec 22 '13 at 16:36
source share

I ran into this problem on Ubuntu 13.10. I didn’t want to crack PHP files because usually phpMyAdmin works out of the box after installing the package from Ubuntu repositories. Instead, I ran:

 sudo dpkg-reconfigure phpmyadmin

During the migration, I said yes to reinstall the phpMyAdmin database. Subsequently, the problem disappeared. I have a vague recollection that I will answer “No” to this question earlier, during installation or update. This is probably why the problem arose first.

+103
Jul 24 '14 at 15:23
source share

You just change the 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 the apache server with the command,

 sudo service apache2 restart
+40
Apr 25 '14 at 7:04
source share

Try sudo dpkg-reconfigure phpmyadmin

Replace the configuration file / etc / phpmyadmin / config -db.php with the new version

+16
Jan 12 '15 at 7:45
source share

I had to change these lines:

 $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 __ " in ['bookmarktable'] and " _ " in 'pma_bookmark'

+8
Jun 04 '14 at 12:05
source share

you must reconfigure phpmyadmin On the terminal:

  • sudo dpkg-reconfigure phpmyadmin
+6
Aug 30 '14 at 10:20
source share

I found a solution to fix this.

Edit the file /etc/phpmyadmin/config.inc.php.

Search:

 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 apache service and try. Hope it helps. Thank.

+4
May 09 '16 at 4:53
source share

I am using the version of Windows 7 Xampp version phpmyadmin, and none of the above, or below, if this message is not canceled, the answers worked out. I tried to uninstall Xampp and upgrade to a higher version by manually changing the values ​​in the config folder, importing .sql files from some github page and even watching a YouTube video, but none of the suggestions worked.

Decision:

Delete ALL in the folder C: \ xampp \ phpMyAdmin> go to https://www.phpmyadmin.net/ and download the latest version> extract everything so that C: \ xampp \ phpMyAdmin and your problem is solved.

^^^^^ Read this if you don't want to spend hours searching Google for a lot of failed solutions. It is much easier! ^^^^^^

+2
Feb 12 '17 at 7:01
source share

in linux os, such as Debian or Ubutu, you can just try these methods, for the first time remove phpmyadmin with the -purge option:

 sudo apt-get remove --purge phpmyadmin

then install again

 sudo apt-get install phpmyadmin

thats works great :)

+1
Feb 27 '15 at 9:45
source share

You just need to change the table names according to the error in /etc/phpmyadmin/config.inc.php

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

to

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

assign the table names accordingly, and everything will be fine.

For me, sudo dpkg-reconfigure phpmyadmin caused more problems when I chose the option to reinstall the database

+1
Mar 28 '15 at 8:54
source share

I had the same problem with the latest Lampp with MariaDB on Ubuntu Server 14.04, and @iceberg's solution worked very well:

You just change the 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 the apache server with the command,

 sudo service apache2 restart

Lampp config.inc.php is located in /opt/lampp/phpmyadmin/config.inc.php and for it to work, I also needed to change

 $ cfg ['Servers'] [$ i] ['tracking'] = 'pma__tracking';

to

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

and restart the lamp:

 sudo /opt/lampp/lampp stop sudo /opt/lampp/lampp start
+1
Dec 08 '15 at 14:15
source share

Steps:

  • Just download create_table.sql from GitHub and save its file on your system.
  • Then go to your phpMyAdmin.
  • And click "Import from the top tab."
  • Finally, select create_table.sql and load it.

In the end, it works for me and hopefully will work for you.

+1
Mar 04 '16 at
source share

I just found create_tables.sql saved on my desktop, opened phpMyAdmin, selected the import tab, selected create_tables.sql, clicked ok

0
May 04 '15 at 1:12
source share

To describe the multiple answer in detail here, there is an error in the config.inc.php file in which the "_" symbol is missing, which is this answer.

To fix this, you can add "pma__table_uiprefs.inc.php" to the /etc/phpmyadmin/conf.d folder, leaving the main configuration files intact ...

<?php foreach($cfg['Servers'] as $i => $v) { $cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs'; }

0
Apr 14 '16 at 6:23
source share

A very simple solution is to edit /etc/phpmyadmin/config.inc.php and put

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

It just controls the user interface and who needs the interface if it interferes with the display of actual data.

amuses

0
Dec 30 '16 at 13:19
source share

Clear your cookies

When using PHPMyAdmin configured with several databases, one of which has a phpmyadmin table and the other does not; phpmyadmin will save the database settings with a table in your cookies, and then try to load them with a database that does not have this table.

To check, try using the incognito window.

0
May 21 '18 at 7:54
source share

In the phpmyadmin database, create this table, there is a name for this table, it can be pma_table_uiprefs and not pma__table_uiprefs

CREATE TABLE IF NOT EXISTS pma_table_uiprefs ( username VARCHAR (64) NOT NULL, db_name VARCHAR (64) NOT NULL, table_name VARCHAR (64) NOT NULL, prefs text NOT NULL, last_update timestamps NOT NULL DEFAULT CURRENT_TIMEST last_update username , db_name , table_name )) COMMENT = 'Tables' 'User Interface Settings' DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

0
May 24 '18 at 15:49
source share

I had similar problems with phpMyAdmin after changing MySQL InnoDB setting to innodb_file_per_table = 1
Move InnoDB tables to separate files.

None of the other answers helped in my case, nor sudo dpkg-reconfigure phpmyadmin nor importing create_tables.sql . Both failed.

What helped was that in my.cnf there were no innodb_file_format any default-storage-engine , default-tmp-storage-engine and innodb_file_format

After restarting MySQL and uninstalling + reinstalling phpMyAdmin there are no more errors.

0
Sep 04 '18 at 16:59
source share

The entire configuration section is commented out (/etc/phpmyadmin/config.inc.php):

from:

/ * Optional: Advanced phpMyAdmin Functions * /

so that:

/ * Optional: phpMyAdmin advanced functions

I just needed simple data access ... This problem should not block the display of phpmyadmin tables ...

0
Dec 24 '18 at 9:34
source share

Help for Ubuntu - sudo dpkg-reconfigure phpmyadmin

0
Jul 25 '19 at 8:42
source share


More articles:


All Articles