Why is phpMyAdmin not fully configured?

Question

With the installation of localhost MySQL 5.6.20 and phpMyAdmin 4.2.7.1 on Mac OS X 10.9.4, I used phpmyadmin/examples/create_tables.sql edited to activate the necessary GRANT SELECT, INSERT, DELETE, UPDATE on phpmyadmin for my managing user.

With config.inc.php below, when I run phpMyAdmin, whether root or as a user of this control, I get an error: The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click here. The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click here.

This link displays a long list of configuration options, not OK, including:

 $cfg['Servers'][$i]['relation'] ... $cfg['Servers'][$i]['table_info'] .. $cfg['Servers'][$i]['table_coords'] ... $cfg['Servers'][$i]['userconfig'] ... 

But I installed them in config.inc.php .

In the main phpMyadmin window, when I see the executed requests, I see:

 [error] => Table 'phpmyadmin.pma_recent' doesn't exist [count] => 1 [query] => SELECT `tables` FROM `phpmyadmin`.`pma_recent` WHERE `username` = 'root' 

But when I run mysql -u root -p from the command line, then use phpmyadmin; and show tables; I get a list:

 +-----------------------+ | Tables_in_phpmyadmin | +-----------------------+ | pma__bookmark | | pma__column_info | | pma__designer_coords | | pma__history | | pma__navigationhiding | | pma__pdf_pages | | pma__recent | | pma__relation | | pma__savedsearches | | pma__table_coords | | pma__table_info | | pma__table_uiprefs | | pma__tracking | | pma__userconfig | | pma__usergroups | | pma__users | +-----------------------+ 

What's wrong?

(I saw the “answer” in phpMyAdmin - config.inc.php configuration?, But that didn't help.)

Here's the beginning of config.inc.php , with some comments stripped and confidential information hidden.

 <?php $cfg['blowfish_secret'] = 'my secret'; /* Servers configuration */ $i = 0; /* Server: localhost [1] */ $i++; $cfg['Servers'][$i]['verbose'] = 'my localhost'; $cfg['Servers'][$i]['host'] = 'localhost'; $cfg['Servers'][$i]['port'] = ''; $cfg['Servers'][$i]['socket'] = '/tmp/mysql.sock'; $cfg['Servers'][$i]['connect_type'] = 'tcp'; $cfg['Servers'][$i]['extension'] = 'mysqli'; /* Authentication type */ $cfg['Servers'][$i]['auth_type'] = 'cookie'; $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = ''; /* * phpMyAdmin configuration storage settings. */ /* User used to manipulate with storage */ $cfg['Servers'][$i]['controluser'] = 'mypmacontroluser'; $cfg['Servers'][$i]['controlpass'] = 'mypassword'; /* Storage database and tables */ $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]['table_uiprefs'] = 'pma_table_uiprefs'; $cfg['Servers'][$i]['tracking'] = 'pma_tracking'; $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords'; $cfg['Servers'][$i]['userconfig'] = 'pma_userconfig'; $cfg['Servers'][$i]['recent'] = 'pma_recent'; $cfg['Servers'][$i]['users'] = 'pma__users'; $cfg['Servers'][$i]['usergroups'] = 'pma__usergroups'; $cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding'; /* End of servers configuration */ 

Answer 1

I do not know phpMyAdmin, so I can’t say how this parameter should be, but in any case, just looking at the question, the table will not be named here sequentially:

 $cfg['Servers'][$i]['recent'] = 'pma_recent'; 

written with one (1) underline.

The table itself, as for SHOW TABLES, is written in two (2) underscores.

 +-----------------------+ | Tables_in_phpmyadmin | +-----------------------+ ... | pma__recent | 

So yes, MySQL will complain that:

 Table 'phpmyadmin.pma_recent' doesn't exist 

because tables do not really exist.

Answer 2

Do not create this file manually. Use the installation wizard through a browser to create a valid configuration.