Installing phpMyAdmin outside CPanel or Plesk
CPanel and Plesk have phpMyAdmin inside their Control Panel/Administration Site. Only ‘root or ’superuser’ can access phpMyAdmin. This can be difficult if we have a development team, which each member needs to access databases. So we install phpMyAdmin outside Control Panel.
- Download phpMyAdmin version 2.9.x or above
- Extract phpMyAdmin and upload to server. Create a ‘not easy guess” folder name
- Change config.sample.inc.php to config.inc.php. Fill in a blowfish secret word and empty username and password in config.inc.php
- Don’t give ‘root’ password, create user and password for each member.
- Protect folder
CPanel : Site Management Tools > Web Protect
Plesk : Domains > Hosting > Directories (Protected Directories) - Don’t give username and password for Protected Folder or Protected Directory to people who doesn’t have right to access the folder.
Anjanesh | August 17th, 2007 at 10:00 am Said:
I normally install phpMyAdmin to a SSL folder (httpsdocs in Plesk and private_html in DirectAdmin). Many shared hosts provide shared SSL too.
and I have my config.inc.php file like this
Except for DirectAdmin, where users’ default shared phpMyAdmin lies in https://domain.com/phpMyAdmin (private_html/phpMyAdmin/), you should change the folder name to something other than phpMyAdmin if uploading to private_html directory and correspondingly change $cfg['PmaAbsoluteUri'] value.
Kate | August 17th, 2007 at 7:34 pm Said:
Thank you. I’ll try using SSL.
Anjanesh | August 18th, 2007 at 2:13 am Said:
and I have my config.inc.php file like thisI was wondering where did the php code go after that line.
Realized that your blog took down the content in between <?php and ?> <?php$cfg['PmaAbsoluteUri'] = ‘https://domain.com/phpMyAdmin/’;$cfg['blowfish_secret'] = ’secret-key’;$cfg['ServerDefault'] = 1;$cfg['Servers'][1]['host'] = ‘localhost’;$cfg['Servers'][1]['auth_type'] = ‘cookie’;$cfg['LoginCookieValidity'] = 864000;?>