Share this:

phpMyAdmin is web based client written in php for managing MySQL databases. It provides an user friendly web interface to access and manage your databases.

phpmyadmin-banner

Features of phpMyAdmin:

    • Friendly web interface
    • Supported most of the MySQL features:
      • Browse and drop databases, tables, views, fields and indexes.
      • Create, copy, drop, rename and alter databases, tables, fields and indexes
      • Server maintenance for databases and tables.
      • Manage MySQL users and there privileges
      • Manage stored procedures and triggers
    • Import data from CSV and SQL
    • Export data to various formats: CSV, SQL, XML, PDF, ISO/IEC 26300 – OpenDocument Text and Spreadsheet, Word, LATEX and others
    • Administering multiple servers
    • Creating complex queries using Query-by-example (QBE)

This article will you to install phpMyAdmin on CentOS/RedHat System. It required Apache, PHP and MySQL to be installed on server. If you do not have them read our turtorials to how to install them.

Installing Apache MySQL PHP on CentOS and RedHat

Step 1: Add REMI Repository in System

phpMyAdmin most updated package is available under remi repository. Install it in your system using following commands.

CentOS/RHEL 6:
# rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm 

CentOS/RHEL 5:
# rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-5.rpm 

Step 2: Install Package using Yum

After adding remi repository, install phpMyAdmin using yum package manager. All the dependencies will automatically be installed.

# yum --enablerepo=remi install phpMyAdmin
Step 3: Configure phpMyAdmin to Access Remotly

phpMyAdmin bye default allowed to access from localhost only. If you want to make it accessible from remote computers edit /etc/httpd/conf.d/phpMyAdmin.conf and update all 127.0.0.1 with your network like below or enable phpMyAdmin access for everyone.

Alias /phpMyAdmin /usr/share/phpMyAdmin
Alias /phpmyadmin /usr/share/phpMyAdmin

## Comment below section to allow everyone 

<Directory /usr/share/phpMyAdmin/>
    <IfModule !mod_authz_core.c>
     Order Deny,Allow
     Deny from All
     Allow from 192.168.1.0/24
     Allow from ::1
   </IfModule>
</Directory>

After updating phpMyAdmin apache configuration file, restart Apache service to reload new settings.

# service httpd restart
Step 4: Access phpMyAdmin in Browser

Now you can access phpMyAdmin in browser using following url. Change svr1.tecadmin.net with your server ip/fqdn.


http://svr1.tecadmin.net/phpMyAdmin/

Login Details: Use MySQL username and password.

Install phpMyAdmin

Congratulation’s You have successfully installed phpMyAdmin. Using single phpMyAdmin we can manage multiple MySQL servers by adding multiple remote MySQL server. Use this article to add multiple MySQL hosts in phpMyAdmin.