Prev | Current Page 44 | Next

Marc Delisle

"Mastering phpMyAdmin 2.11 for Effective MySQL Management"

Chapter 3 gives an overview of the
panels seen now.
Multi-Server Configuration
The config.inc.php file contains at least one server-specific section but we can add
more, enabling a single copy of phpMyAdmin to manage many servers. Let us see
how to configure more servers.
Servers Defined 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
that precedes each section and is crucial to delimit the server sections is also copied.
??? ??? ???
Installing phpMyAdmin
[ 32 ]
Then, at the end of the sections, the following line controls what happens at startup:
$cfg['ServerDefault'] = 1;
The default value, 1, means that phpMyAdmin will connect by itself to the first
server defined or present this server choice by default when using advanced
authentication??”more on this later in this chapter. We can specify any number, for
the corresponding server-specific section. We can also enter the value 0, signifying
no default server, in which case phpMyAdmin will present a server choice:
Arbitrary Server
Another mechanism can be used if we want to be able to connect to an undefined
MySQL server.


Pages:
32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56