phpMyAdmin config.inc.php

This config is for development environment only.

Note: you will also need to do the following:
– Run examples/create_tables.sql
– Create new user pma and grant access to the phpmyadmin database
– The username/password in the below config is pma/pass
– Re-login to phpmyadmin

<?php
 
$cfg['Servers'][1]['host'] = 'localhost';
$cfg['Servers'][1]['connect_type'] = 'socket';
$cfg['Servers'][1]['extension'] = 'mysqli';
$cfg['Servers'][1]['nopassword'] = true;
$cfg['Servers'][1]['auth_type'] = 'config';
$cfg['Servers'][1]['user'] = 'root';
$cfg['Servers'][1]['password'] = '';
$cfg['Servers'][1]['hide_db'] = '^performance_schema|information_schema|phpmyadmin|mysql$';
$cfg['Servers'][1]['AllowNoPassword'] = true;
 
$cfg['Servers'][1]['controluser'] = 'pma';
$cfg['Servers'][1]['controlpass'] = 'pass';
$cfg['Servers'][1]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][1]['bookmarktable'] = 'pma__bookmark';
$cfg['Servers'][1]['relation'] = 'pma__relation';
$cfg['Servers'][1]['userconfig'] = 'pma__userconfig';
$cfg['Servers'][1]['users'] = 'pma__users';
$cfg['Servers'][1]['usergroups'] = 'pma__usergroups';
$cfg['Servers'][1]['navigationhiding'] = 'pma__navigationhiding';
$cfg['Servers'][1]['table_info'] = 'pma__table_info';
$cfg['Servers'][1]['column_info'] = 'pma__column_info';
$cfg['Servers'][1]['history'] = 'pma__history';
$cfg['Servers'][1]['recent'] = 'pma__recent';
$cfg['Servers'][1]['table_uiprefs'] = 'pma__table_uiprefs';
$cfg['Servers'][1]['tracking'] = 'pma__tracking';
$cfg['Servers'][1]['table_coords'] = 'pma__table_coords';
$cfg['Servers'][1]['pdf_pages'] = 'pma__pdf_pages';
$cfg['Servers'][1]['designer_coords'] = 'pma__designer_coords';
$cfg['Servers'][1]['savedsearches'] = 'pma__savedsearches';

Leave a Reply