phpmyadmin – multiple host

using phpmyadmin to manage multiple host

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


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/

the default config


change to


 * 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
        '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


now your phpmyadmin have multiple host




Published by


just to remember what i had known :)

Leave a Reply

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

You are commenting using your 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