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

==================================================================================================

Installing:

 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

Installed:

                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 127.0.0.1

Replace with your workstation IP address:

Require ip 192.168.1.2

Again find the following line:

Allow from 127.0.0.1

Replace as follows:

Allow from 192.168.1.2

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

# service httpd restart

Open a web browser and type the following url:

http://your-server-ip/phpMyAdmin/

OR

http://your-server-ip/phpMyAdmin/