Saturday, October 14, 2017

PHPMYADMIN to Remote Database

1.Open /etc/phpmyadmin/config.inc.php
2.Add the below entry in bottom of the line
$i++;
$cfg['Servers'][$i]['host']          = '10.0.1.4';
3.Login to remote server and create a user with grant privileges for all the databases in server with remote host %
4.Now access the phpmyadmin using the serverip/phpmyadmin and select the server choice to remote server and you can able to access or modify all the databases in remote server.