Installing PHPMyAdmin on Windows XP Pro 7



What do we have in this session 7?

  1. Non root Login



The Non root Login


Next, redo for the controluser and advanced phpmyadmin features as done previously. MySQL root user must not be used to login phpmyadmin. Edit phpmyadmin config file as shown below.


/* User for advanced features */

$cfg['Servers'][$i]['controluser'] = 'pma';

$cfg['Servers'][$i]['controlpass'] = 'pmapass';

/* Advanced phpMyAdmin features */

$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]['tracking'] = 'pma_tracking';

$cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';

/* Contrib / Swekey authentication */

// $cfg['Servers'][$i]['auth_swekey_config'] = '/etc/swekey-pma.conf';



Save the file and then reload the phpmyadmin URL on localhost. Re-login phpmyadmin with username: pma and password: pmapass.


Login phpmyadmin using pma username and its password









The phpmyadmin main page logged by user with less privileges


In this case, pma user (or MySQL users other than root) should be granted with appropriate privileges in order to complete its defined tasks and at the same time can preserve the security. Then the phpmyadmin can be further refined using the config file and please refer to phpmyadmin documentation for the details.





phpmyadmin in action logged as user with less privileges


Can you see the differences?




< PHPMyAdmin 6 | Java and Opensource Friends >





PHPMyAdmin 1 | PHPMyAdmin 2 | PHPMyAdmin 3 | PHPMyAdmin 4 | PHPMyAdmin 5 | PHPMyAdmin 6 | PHPMyAdmin 7 | Java and Opensource Friends