open another mysql database using phpMyAdmin

[infinite_root]

Is it possible to open another mysql database server on the same maching using phpMyAdmin aside running from localhost?

I want to open the content of mysql server 192.168.0.4 from my Webserver which are hosting PhpMyAdmin tool. 192.168.0.2?

If this is possible how can I do this?

Thanks and more power.

[sde]

i don't think phpadmin supports multiple servers. just install 2 different instances of phpmyadmin.

localhost/phpmyadmin1/
localhost/phpmyadmin2/

[idx]

Actually I think I set it up at one point to admin more than one server. Just make sure server 2 allows connections from #1. (typically they'll only be setup to allow access from localhost)


Look in config.inc.php where it has something like:

$i++;
$cfg['Servers'][$i]['host']            = '';
$cfg['Servers'][$i]['port']            = '';
$cfg['Servers'][$i]['socket']          = '';
$cfg['Servers'][$i]['connect_type']    = 'tcp';
$cfg['Servers'][$i]['controluser']     = '';
$cfg['Servers'][$i]['controlpass']     = '';
$cfg['Servers'][$i]['auth_type']       = 'config';

After the $i++ just plug in server 2's info. Then do the same for all your other servers as well.

-r

[bdl]

Not to be argumentative, (heh) but yes, you can configure and administer multiple servers. I know this because my companies' hosts' site has a phpMyAdmin frontend to about 6 servers, and it says so in the documentation.

http://www.phpmyadmin.net/documentation/

[sde]

oh cool .. that makes sense.. i shoulda known, i've looked at that config file many times.

[infinite_root]

To All,

Thanks for all your help.