2016-09-08

PhpMyAdmin is a free and an open source PHP platform used to administer MySQL with a web browser.It supports wide range of operations on MySQL, MariaDB.

Through this user interface frequently used operations like (run MySQL queries, optimize, repair and check tables, change collation and execute other database management commands) can be performed. In this tutorial i will guide you a quick way to install PhpMyAdmin on Linux.

Prerequisites

These guidelines are intended for Install phpMyAdmin on Fedora, CentOS & RHEL with Apache Web Server

SSH client like Putty and proper knowledge to use it.

Make sure you should have installed LAMP before proceeding phpMyAdmin installation.

Some basic knowledge about common Linux commands.

20 minutes of your time with a cup of tea or coffee as always.

Step 1- Check currently available phpMyAdmin package

First of all use the below command to check available phpMyAdmin package on your system.

Step 2- Install and Enable Remi Repository

phpmyadmin updated package is available under Remi repository, You can install is using following commands:

Step 3- Install phpMyAdmin

After adding repository,Fire the below command to install phpMyAdmin using yum package manager. All the dependencies will automatically get installed.

Step 4- Configure phpmyadmin

By default you can access phpmyadmin from your localhost but if you want to access from remote, you need to add your IP to phpMyAdmin.conf file based on your Web Server such as Apache, Nginx & Lighttpd.

which is located under /etc/httpd/conf.d/phpMyAdmin.conf.

Update all 127.0.0.1 with your network like below or enable phpMyAdmin access for everyone.

Step 5- Restart Apache & MariaDB service

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

Step 6- Access phpmyadmin in web browser

Now you can access phpMyAdmin in browser using following URL:

http://localhost/phpmyadmin or http://your-server-ip-address/phpmyadmin or http://127.0.0.1/phpmyadmin and enter the login details.



So this is all you have to do, Also read about Install And Configure PhpMyAdmin On CentOS.Please Give your opinion below if you experience any issues or to discuss your ideas and experiences.

The post Install phpMyAdmin on Fedora, CentOS & RHEL with Apache Web Server appeared first on cPanel Plesk.

Show more