phpMyAdmin - config.inc.php configuration?

phpmyadmin

Solution

I had the same problem for days until I noticed (how could I look at it and not read the code :-(..) that `config.inc.php` is calling `config-db.php`

** MySql Server version: 5.7.5-m15 ** Apache/2.4.10 (Ubuntu) ** phpMyAdmin 4.2.9.1deb0.1

/etc/phpmyadmin/config-db.php:

$dbuser='yourDBUserName';
$dbpass='';
$basepath='';
$dbname='phpMyAdminDBName';
$dbserver='';
$dbport='';
$dbtype='mysql';

Here you need to define your username, password, dbname and others that are showing empty' use default unless you changed their configuration. That solved the issue for me. U hope it helps you. latest.phpmyadmin.docs

Problem

With this configuration i found the error The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click here. When click then the following error is found: ``` $cfg['Servers'][$i]['users'] ... not OK $cfg['Servers'][$i]['usergroups'] ... not ok $cfg['Servers'][$i]['navigationhiding'] ... not OK $cfg['Servers'][$i]['savedsearches'] ... not OK <?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'] = 'config'; $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = ''; $cfg['Servers'][$i]['extension'] = 'mysqli'; $cfg['Servers'][$i]['AllowNoPassword'] = true; $cfg['Lang'] = ''; /* Bind to the localhost ipv4 address and tcp */ $cfg['Servers'][$i]['host'] = '127.0.0.1'; $cfg['Servers'][$i]['connect_type'] = 'tcp'; /* User for advanced features */ $cfg['Servers'][$i]['controluser'] = 'pma'; $cfg['Servers'][$i]['controlpass'] = ''; $cfg['Servers'][$i]['users'] = 'pma_users'; $cfg['Servers'][$i]['usergroups'] = 'pma_usergroups'; /* Advanced phpMyAdmin features */ $cfg['Servers'][$i]['pmadb'] = ''; $cfg['Servers'][$i]['navigationhiding'] = 'pma_navigationhiding'; $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 */ ?> ```

Original source