Databases Reference
In-Depth Information
Configuring for multiple server support
The
config.inc.php
file contains at least one server-specific section; however, we
can add more, enabling a single copy of phpMyAdmin to manage many MySQL
servers. Let us see how to configure more servers.
Defining servers in the configuration file
In the server-specific sections of the
config.inc.php
file, we see lines referring to
$cfg['Servers'][$i]
for each server. Here, the variable
$i
is used so that one can
easily cut and paste whole sections of the configuration file to configure more servers.
While copying such sections, we should take care that the
$i++;
instruction, which
precedes each section and is crucial to delimit the server sections, is also copied.
Then, at the end of the sections, the following line controls the startup:
$cfg['ServerDefault'] = 1;
The default value,
1
, means that phpMyAdmin will use by default the first server
defined. We can specify any number, for the corresponding server-specific section.
We can also enter the value
0
, signifying no default server; in this case a list of
available servers will be presented at login time.
This configuration can also be done via web-based setup. Given here is an example
of a multi-server definition, with the default server being set to
let the user choose
: