How to: CentOS Virtualmin PHPMyadmin Disable Root Logins and Force SSL

After you have installed phpmyadmin with virtualmin into a domain there are two things you need to change in the phpmyadmin config file for this to work

The phpmyadmin file can be found at /home/domain/phpmyadmin/config.inc.php – or what ever you have set it to. If you cant find it you can do a simple

locate config.inc.php

Then lets edit that file:

vim config.inc.php

1. Find the ‘auth_type’ to ‘cookie’. This will be under the /* Authentication type */ comment. The line should read as

$cfg['Servers'][$i]['auth_type'] = ‘cookie’;

 Make sure it is uncommented by removing the “//” before it, and make sure  parameter is set to ‘cookie’.

 2. Find the line that says

$cfg['Servers'][$i]['AllowRoot'] = false;

Make sure it is uncommented by removing the “//” before it, and make sure  parameter is set to ‘false’. If you cant find this line add it.

Now to force SSL:

vim config.inc.php

Find and change to:

$cfg['ForceSSL'] = true;

Make sure it is uncommented by removing the “//” before it, and make sure  parameter is set to ‘true’. If you cant find this line add it.

Find and change to:

$cfg['Servers'][$i]['ssl'] = true;

Make sure it is uncommented by removing the “//” before it, and make sure  parameter is set to ‘true’. If you cant find this line add it.

That’s it!