Database Reference
In-Depth Information
If we examine only the normal server parameters (other parameters will be
covered starting with Chapter 11), we see a section that looks like the following
for each server:
$i++;
$cfg['Servers'][$i]['host'] = '';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['compress'] = FALSE;
$cfg['Servers'][$i]['controluser'] = '';
$cfg['Servers'][$i]['controlpass'] = '';
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['only_db'] = '';
$cfg['Servers'][$i]['hide_db'] = '';
$cfg['Servers'][$i]['verbose'] = '';
In this section, we have to enter in
$cfg['Servers'][$i]['host']
, the hostname or
IP address of the MySQL server—for example,
mysql.mydomain.com
or
localhost
.
If this server is running on a non-standard port or socket, we fill in the correct values
in
$cfg['Servers'][$i]['port']
or
$cfg['Servers'][$i]['socket']
. See the
section on
connect_type
for more details about sockets.
The displayed server name inside phpMyAdmin's interface will be the one entered in
'host'
(unless we enter a non-blank value in the following parameter). For example:
$cfg['Servers'][$i]['verbose'] = 'Test server';
This feature can thus be used to hide the real server hostname as seen by the users.
extension
The traditional mechanism PHP uses to communicate with a MySQL server, as
available in PHP before version 5, is the
mysql
extension. This extension is still
available in PHP 5. However, a new extension called
mysqli
has been developed and
should be preferred for PHP 5, because of its improved performance and its support
of the full functionality of MySQL family 4.1.x. This extension is designed to work
with MySQL version 4.1.3 and higher.
In phpMyAdmin version 2.6.0, a new library has been implemented. This has made
possible the use of both extensions, choosing either one for a particular server. We
indicate the extension we want to use in
$cfg['Servers'][$i]['extension']
.
Search WWH ::
Custom Search