Oct 10, 2014

install phpmyadmin for multi server multi port, phpmyadmin single signon

i want to use one server to manage some mysql server in some ip's

let start,.


a. installed apache
b. installed php and its library for mysql connection

install phpmyadmin single signon

1. download phpmyadmin from sourceforge  extract it and put on your apache root document
2. edit your configuration file (copy from config.sample.inc.php , make it to be config.inc.php )

/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'signon'; //'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['AllowNoPassword'] = false;

$cfg['Servers'][$i]['extension']     = 'mysqli';
$cfg['Servers'][$i]['auth_type']     = 'signon';
$cfg['Servers'][$i]['SignonSession'] = 'SignonSession';
$cfg['Servers'][$i]['SignonURL']     = 'signon.php';

3. download and copy this file to your extracted directory

4. reboot your apache

5. navigate to your serverUrl/phpmyadmin_folder_location

Read more ...