phpmyadmin – multiple host

using phpmyadmin to manage multiple host

the default, phpmyadmin only host to localhost, there’s no other choice host database

phpmyadmin-default-11072016-061158-am

the problem when you have multiple host database mysql and still love phpmyadmin a client database

solution you can create multiple host database in php myadmin

# edit phpmyadmin config file
geany /var/www/phpmyadmin/config.inc.php

the default config

phpmyadmin-config-before-11072016-060408-am

change to

phpmyadmin-config-after-11072016-060734-am

/*
 * Servers configuration
 */

$i = 0;

$_default_cfg_server = array(
    'auth_type' => 'cookie',
    'verbose'    => 'localhost',
    'host'        => 'localhost',
    'connect_type'=> 'tcp',
    'compress'    => false,
    'AllowNoPassword' => true
);

$servers = array(
    array(), // this our localhost, so let it be
    array(
        'verbose' => 'Stela DB',
        'host'    => '123.456.789.012'
    )
);

foreach($servers as $svr) 
    $cfg['Servers'][++$i] = array_merge($_default_cfg_server, $svr);

save and refresh phpmyadmin login page

phpmyadmin-multiplehost-11072016-060049-am

now your phpmyadmin have multiple host

 

 

Published by

G3n1k

just to remember what i had known :)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s