If this default
socket, as defined in php.ini, does not correspond to the real socket assigned to the
MySQL server, we have to put the socket name (for example, /tmp/mysql.sock) in
$cfg['Servers'][$i]['socket'].
If the hostname is not localhost, a tcp connection will occur??”here, on the special
port 3307. However, leaving the port value empty would use the default 3306 port:
$cfg['Servers'][$i]['host'] = 'mysql.mydomain.com';
$cfg['Servers'][$i]['port'] = '3307';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysql';
compress Configuration
Starting with PHP 4.3.0 and MySQL 3.23.49, the protocol used to communicate
between PHP and MySQL allows a compressed mode. Using this mode provides
better efficiency. To take advantage of this mode, simply specify:
$cfg['Servers'][$i]['compress'] = TRUE;
Authentication Type: config
For our first test, we will use the config authentication type, which is easy to
understand. However, in the Multi-User Installation section, we will see more
powerful and versatile ways of authenticating.
Although it seems that we are logging in to phpMyAdmin, we are not! The
authentication system is a function of the MySQL server. We are merely using
phpMyAdmin (which is running on the web server) as an interface that sends our
user and password information to the MySQL server.
Pages:
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54