Today i installed phpMyAdmin on
So that all clients hosted on different servers can use this to manage their MySQL Database.
Linux and FreeBSD servers have cpanel control panel which have its own phpMyAdmin installed. On Windows servers we have HELM control panel, which do not have a phpMyAdmin installed. So far clients install their own copy of phpMyAdmin as only few use MySQL on Windows server. Having a phpMyAdmin that allow connection to any server will allow anyone to manage MySQL anywhere on internet.
This is done with few simple change in config.inc.php file
OPEN
config.inc.php
FIND
$cfg[‘PmaAbsoluteUri’] = ”;
REPLACE WITH
$cfg[‘PmaAbsoluteUri’] = ‘http://phpmyadmin.hosthat.com/’;
FIND
$cfg[‘blowfish_secret’] = ”;
REPLACE WITH
$cfg[‘blowfish_secret’] = ‘GoodBoy’;
FIND
$cfg[‘Servers’][$i][‘auth_type’] = ‘config’;
REPLACE WITH
$cfg[‘Servers’][$i][‘auth_type’] = ‘cookie’;
FIND
$cfg[‘AllowArbitraryServer’] = FALSE;
REPLACE WITH
$cfg[‘AllowArbitraryServer’] = TRUE;
Thats all, now phpMyAdmin will allow you to connect to any server.