HostOnNet Blog

Installing phpMyAdmin for multiple servers

Looking for Linux Server Admin or WordPress Expert? We can help.

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.

Posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.