Add Remote Database Dropdown in PhpMyAdmin

[Gordon55M]

I'm trying to configure phpmyadmin screen to have a dropdown of my remote databases. I tried adding this on the line below

Code: Select all

$i++;

of /etc/phpmyadmin/config.inc.php

Code: Select all

$cfg['Servers'][$i]['verbose']       = 'Remote MariaDB';// Change this to whatever you $
$cfg['Servers'][$i]['host']          = 'IPofRemoteServer';
$cfg['Servers'][$i]['port']          = '3306';
$cfg['Servers'][$i]['connect_type']  = 'tcp';
$cfg['Servers'][$i]['extension']     = 'mysqli';
$cfg['Servers'][$i]['compress']      = FALSE;
$cfg['Servers'][$i]['auth_type']     = 'cookie';

$i++;

And I can't login with the VestaCP user. I don't get a drop-down to choose servers. When I try to login using a VestaCP created database and user I can't login, however when I type in the root db user and password I can see all databases. Is there a way to make it so that when I click the PhpMyAdmin button in VestaCP the users can access only their database on the remote db?