Enable PhpMyAdmin’s Extra Features

PhpMyAdmin is one of the most used tools when it comes to managing you databases. By default, PhpMyAdmin does a great job. However, it comes with a lot of handy extra extensions which can be easily activated. In this article, we will activate these extensions and see what they can do for us.

Setup

Before you can continue, please make sure PhpMyAdmin is up and running. After logging in, you will probably notice this message at the bottom of the main panel:

The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. To find out why click here. 

Clicking on here will lead you to a page indicating that you didn’t activate all extensions yet. You can activate them, by changing the config.inc.php file and adding the following lines.

$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'pmapass';
$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]['pdf_pages'] = 'pma__pdf_pages';
$cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';
$cfg['Servers'][$i]['column_info'] = 'pma__column_info';
$cfg['Servers'][$i]['history']  

Truncated by Planet PHP, read more at the original (another 4555 bytes)

more