Databases
StackOverflow2013
Postsdbo
POphpMyAdmin configuration storage issue
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POphpMyAdmin configuration storage issue
    primarykey
    data
    text
    <p>I'm well aware that this is a commonly asked question, and I've gone through countless posts here, and elsewhere, but I can't seem to get this to work.</p> <p>I am seeing this error:</p> <p><code>The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated.</code></p> <p>This is my configuration file:</p> <pre><code>$cfg['Servers'][$i]['controluser'] = 'pma'; $cfg['Servers'][$i]['controlpass'] = ''; $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'; </code></pre> <p>There is a user called PMA with no password and full permissions.</p> <p>I have a database called phpmyadmin, and it was populated with the tables generated in the <code>examples/create_tables.sql</code> script. I cannot browse to these tables and see the contents, however because <code>SELECT command denied to user ''@'localhost' for table 'pma__table_uiprefs'</code> (I am logged into the root user).</p> <p>The query phpMyAdmin tries to run when I try to access any of the configuration tables is:</p> <pre><code>SELECT `prefs` FROM `phpmyadmin`.`pma__table_uiprefs` WHERE `username` = 'root' AND `db_name` = 'phpmyadmin' AND `table_name` = 'pma__bookmark' </code></pre> <p>I have cleared by browsers cache, restarted apache, done all of the little tricks I've seen elsewhere but all that's doing is making me frustrated.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USIan Spence
    1. USIan Spence
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COthe second error message you provided, "SELECT command denied" suggests you are not being recognized as 'root'. Can you clarify what action you took that generated the error? e.g. what command did you enter, how did you try to 'browse to these tables'?
      singulars
      1. POphpMyAdmin configuration storage issue
      1. USRyan
    2. CO@Ryan I'm not actually performing any command, but I get this error if I try to navigate to one of the tables in phpmyadmin. I edited the post with the query phpMyAdmin tries to run.
      singulars
      1. POphpMyAdmin configuration storage issue
      1. USIan Spence
    3. COI understand now, you are logged into phpmyadmin's web interface as 'root', then you click on 'databases', then 'phpmyadmin', then 'pma__table_uiprefs' and you get your error, is that correct? Your question seems environment specific, it would help to understand what OS, phpmyadmin version... are you using XAMPP, cpanel, etc. Perhaps this will help: http://stackoverflow.com/questions/17376637/xampp-select-command-denied-to-user-localhost-for-table-users
      singulars
      1. POphpMyAdmin configuration storage issue
      1. USRyan
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload