Skip to main content

How to install phpmyadmin on centos 7

Phpmyadmin is an opensource tool to manage MySQL database using web browser. it can perform almost all tasks such as creating,deleting,modifying databases,users,tables and fields .
This guide helps you to install phpmyadmin on centos 7. it contains step by step installation through YUM using EPEL repository.

Prerequisite – LAMP server

Before starting phpmyadmin installation, You must setup LAMP server on your centos 7 server. Copy and paste below command in terminal for quick setup . At the end, you need to provide some inputs .
» leave blank for current mysql password.
» provide new password and press enter for the rest.
yum -y install httpd mariadb-server mariadb php php-mysql php-gd php-pear php-mbstring && systemctl start httpd.service && systemctl enable httpd.service && systemctl start mariadb && systemctl enable mariadb && firewall-cmd --permanent --add-service http && systemctl restart firewalld.service && mysql_secure_installation
You can also refer this guide – Install LAMP server on centos 7 for more detailed setup.

Install phpmyadmin on centos 7

By default, centos 7 repository does not contains phpmyadmin package. we need to enable EPEL repository. Find the latest EPEL for centos 7 from EPEL for Centos 7
Step 1 » Download and install epel-release-7-x.noarch.rpm file . or install directly by copying the rpm link.
[root@krizna ~]# rpm -ivh http://epel.mirror.net.in/epel/7/x86_64/e/epel-release-7-1.noarch.rpm
Step 2 » Update repositories by issuing below command .
[root@krizna ~]# yum check-update
Step 3 » Now install phpmyadmin package along with dependencies.
[root@krizna ~]# yum -y install phpmyadmin
Step 4 » After installation, Open /etc/httpd/conf.d/phpMyAdmin.conf file ( Apache config file for phpmyadmin ) and edit as follows.
Find these lines . ( Found 2 times )

Replace with

Step 5 » Restart Apache service .
[root@krizna ~]# systemctl restart httpd.service
Step 6 » Now open http://serverIP/phpmyadmin in your browser. You can login using root as username and mysql root password.
install phpmyadmin on centos 7
That’s it . Have a nice day.

  • Ric

    Works fine for me, thanks dude!

  • Jorge

    Great Post!! Like It!

  • hi Krizna,
    I already install phpmyadmin,
    the error message
    Forbidden

    You don’t have permission to access /phpmyadmin on this server.

  • Caroline

    Just a little correction ! Link in step 1 to install EPEL repo is dead.

  • dd

    very simple But~~.perfectly Works fine! thanks

  • Tony Lam

    after install all step above and than yum -y install phpmyadmin I got “no package phpmyadmin available” please help.