PHPMyAdmin Configuration

Introduction

For a general definition see: http://en.wikipedia.org/wiki/PHPMyAdmin, but more comprehensive information is available from the offical site at http://www.phpmyadmin.net/.

This application can be used to configure MySQL databases using PHP.

The following guidance might be useful in helping to configure PHPMyAdmin on an Apache Web-server running on Linux.

My PHP Server Configuration

Donload and install the lastest version, e.g.:

[root@host phpmyadmin]# yum install phpmyadmin
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * addons: mirror.sov.uk.goscomb.net
 * base: mirror.sov.uk.goscomb.net
 * extras: mirror.sov.uk.goscomb.net
 * rpmforge: fr2.rpmfind.net
 * updates: mirror.ukhost4u.com
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package phpmyadmin.noarch 0:2.11.10-2.el5.rf set to be updated
--> Processing Dependency: php-mcrypt for package: phpmyadmin
--> Running transaction check
---> Package php-mcrypt.i386 0:5.1.6-15.el5.centos.1 set to be updated
--> Processing Dependency: libmcrypt.so.4 for package: php-mcrypt
--> Running transaction check
---> Package libmcrypt.i386 0:2.5.8-4.el5.centos set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

=========================================================================================================
 Package                Arch               Version                            Repository            Size
=========================================================================================================
Installing:
 phpmyadmin             noarch             2.11.10-2.el5.rf                   rpmforge             4.3 M
Installing for dependencies:
 libmcrypt              i386               2.5.8-4.el5.centos                 extras               116 k
 php-mcrypt             i386               5.1.6-15.el5.centos.1              extras                16 k

Transaction Summary
=========================================================================================================
Install       3 Package(s)
Upgrade       0 Package(s)

Total download size: 4.4 M
Is this ok [y/N]: y
Downloading Packages:
(1/3): php-mcrypt-5.1.6-15.el5.centos.1.i386.rpm                                  |  16 kB     00:00
(2/3): libmcrypt-2.5.8-4.el5.centos.i386.rpm                                      | 116 kB     00:00
(3/3): phpmyadmin-2.11.10-2.el5.rf.noarch.rpm                                     | 4.3 MB     00:04
---------------------------------------------------------------------------------------------------------
Total                                                                    964 kB/s | 4.4 MB     00:04
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing     : libmcrypt                                                                         1/3
  Installing     : php-mcrypt                                                                        2/3
  Installing     : phpmyadmin                                                                        3/3

Installed:
  phpmyadmin.noarch 0:2.11.10-2.el5.rf

Dependency Installed:
  libmcrypt.i386 0:2.5.8-4.el5.centos               php-mcrypt.i386 0:5.1.6-15.el5.centos.1

Complete!
[root@host phpmyadmin]#

To setup under Apache the /etc/httpd/conf.d/phpmyadmin.conf configuration file was adjusted to:

#
#  Web application to manage MySQL
#

Alias /phpmyadmin /usr/share/phpmyadmin
Alias /phpMyAdmin /usr/share/phpmyadmin
Alias /mysqladmin /usr/share/phpmyadmin
Alias /mysql /usr/share/phpmyadmin


  Order Deny,Allow
  Deny from all
  Allow from localhost 192.168.0.0/24

Web pages

Web pages http://localhost/phpmyadmin/index..php are served up by the PHP processor in the client browser.

Initial running of the page asks for username and password (of phpmyadmin on localhost). This is the root username and password (and that is changed from balnk if changed above).

General Links

For general links to useful references when setting up PHP see: Apache resources on the Internet.

The following general links are useful references when setting up PHPMyAdmin: