Search Engine



RedhatEnterpriseLinux Blog

Installing and Configuring PhpMyAdmin-3.5.1

Installing and Configuring PhpMyAdmin-3.5.1

PhpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the World Wide Web. Most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, while you still have the ability to directly execute any SQL statement. It comes with an intuitive web interface, support for most MySQL features.

Install phpMyAdmin

Type the following command:
# yum search phpmyadmin
# yum -y install phpmyadmin

Sample outputs:

Loaded plugins: rhnplugin
Setting up Install Process
Resolving Dependencies
There are unfinished transactions remaining. You might consider running yum-complete-transaction first to finish them.
--> Running transaction check
---> Package phpMyAdmin.noarch 0:3.5.1-1.el6 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
 Package                  Arch                 Version                   Repository          Size
 phpMyAdmin               noarch               3.5.1-1.el6               epel               4.2 M
Transaction Summary
Install       1 Package(s)
Total download size: 4.2 M
Installed size: 17 M
Downloading Packages:
phpMyAdmin-3.5.1-1.el6.noarch.rpm                                          | 4.2 MB     00:00
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : phpMyAdmin-3.5.1-1.el6.noarch                                                  1/1
  Verifying  : phpMyAdmin-3.5.1-1.el6.noarch                                                  1/1
                phpMyAdmin.noarch 0:3.5.1-1.el6

Configure phpMyAdmin

You need to edit /etc/httpd/conf.d/phpMyAdmin.conf, enter:
# vi /etc/httpd/conf.d/phpMyAdmin.conf

It allows only localhost by default. You can setup HTTPD and allow LAN / WAN users or DBA user to manage the database over www. Find line that read follows

Require ip

Replace with your workstation IP address:

Require ip

Again find the following line:

Allow from

Replace as follows:

Allow from

Save and close the file. Restart Apache / httpd server:
# service httpd restart

Open a web browser and type the following url:



Post a Comment

Powered by Blogger.


Copyright © Redhat Enterprise linux. Original Concept and Design by My Blogger Themes
My name is Abdul Razaq but people call me Raziq. Here is my home page: I live in Quetta, Pakistan and work as an IT-Engineer.