Fedora Linux Legacy Blog: How To Install PHPMyAdmin on Fedora 9

Friday, September 5, 2008

How To Install PHPMyAdmin on Fedora 9

phpMyAdmin is an opensource tool written in PHP intended to handle the administration of MySQL database and table over the web. Currently, phpmyadmin can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, manage privileges, export data into various formats and is being distributed in more than 50 languages.

PHPMyAdmin Installation on Fedora

Fedora 9 ISO images comes with PHP, MySQL and Apache as part of its distribution release. It is a requirement for PHPMyAdmin to work that the below services are currently installed, and running.

MySQL as Backend Database Server
Apache as HTTP Web server - Installation Here
PHP scripting language - Installation Here

Step One

To install PHPMyAdmin using yum, simply issue

# yum -y install phpMyAdmin.noarch

Step Two

PHPMyAdmin Security Access

By default installation, phpmyadmin administration page can only be accessed from localhost via web browser for added security. If you wish to access phpmyadmin page from multiple hosts, modify phpmyadmin conf page as shown below

# vi /etc/httpd/conf.d/phpMyAdmin.conf

and edit the necessary settings. For example, if you require phpmyadmin web page to be accessible from a computer host with an IP address of 123.123.123.123, edit phpMyAdmin.conf to reflect the below similar lines

order deny,allow
deny from all
allow from 127.0.0.1
allow from 123.123.123.123

Save, exit and reload apache web server.

# service httpd reload

Step Three

PHPMyAdmin User Access Authentication

Before PHPMyAdmin can successfully connect to MySQL backend database, a MySQL username and password is needed to gain authorization to MySQL database server . To do this, simply edit PHPMyAdmin conf file like so

# vi /etc/phpMyAdmin/config.inc.php

and modify the similar lines.

$cfg['Servers'][$i]['auth_type'] = 'http'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'USERNAME'; // MySQL user
$cfg['Servers'][$i]['password'] = 'PASSWORD'; // MySQL password (only needed

Replace USERNAME and PASSWORD with your MySQL username and password respectively.

By default, PHPMyadmin connects to MySQL via localhost with default port and socket. If you wish to modify these settings, change the below similar lines

$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address
$cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port
$cfg['Servers'][$i]['socket'] = ''; // Path to the socket - leave blank for default socket

to fit your needs.

And finally, launch your browser and point it to your PHPMyAdmin web page.

For localhost
http://localhost/phpMyAdmin/

For non-localhost apache server
http://123.123.123.123/phpMyAdmin/

Enter your MySQL username and password.

A similar phpmyadmin screenshot