Add Remote Database Dropdown in PhpMyAdmin
Posted: Thu Sep 03, 2015 10:19 pm
I'm trying to configure phpmyadmin screen to have a dropdown of my remote databases. I tried adding this on the line below of /etc/phpmyadmin/config.inc.php
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?
Code: Select all
$i++;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++;