How to install phpmyadmin on centos 7
\nPhpmyadmin 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 .
\nThis guide helps you to install phpmyadmin on centos 7. it contains step by step installation through YUM using EPEL repository.
\nPrerequisite \u2013 LAMP server
\nBefore 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 .
\n\u00bb leave blank for current mysql password.
\n\u00bb provide new password and press enter for the rest.
\nyum -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<\/p>\n
You can also refer this guide \u2013 Install LAMP server on centos 7 for more detailed setup.<\/p>\n
Install phpmyadmin on centos 7
\nBy 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
\nStep 1 \u00bb Download and install epel-release-7-x.noarch.rpm file . or install directly by copying the rpm link.
\n[root@rmohan ~]# rpm -ivh http:\/\/epel.mirror.net.in\/epel\/7\/x86_64\/e\/epel-release-7-1.noarch.rpm<\/p>\n
Step 2 \u00bb Update repositories by issuing below command .
\n[root@rmohan ~]# yum check-update<\/p>\n
Step 3 \u00bb Now install phpmyadmin package along with dependencies.
\n[root@rmohan ~]# yum -y install phpmyadmin<\/p>\n
Step 4 \u00bb After installation, Open \/etc\/httpd\/conf.d\/phpMyAdmin.conf file ( Apache config file for phpmyadmin ) and edit as follows.
\nFind these lines . ( Found 2 times )
\n# Apache 2.4
\n<RequireAny>
\nRequire ip 127.0.0.1
\nRequire ip ::1
\n<\/RequireAny><\/p>\n
# Apache 2.4
\n<RequireAny>
\nRequire ip 127.0.0.1
\nRequire ip ::1
\n<\/RequireAny>
\nReplace with
\n# Apache 2.4
\n<RequireAny>
\n# Require ip 127.0.0.1
\n# Require ip ::1
\nRequire all granted
\n<\/RequireAny><\/p>\n
# Apache 2.4
\n<RequireAny>
\n# Require ip 127.0.0.1
\n# Require ip ::1
\nRequire all granted
\n<\/RequireAny><\/p>\n
tep 5 \u00bb Restart Apache service .
\n[root@rmohan ~]# systemctl restart httpd.service<\/p>\n
Step 6 \u00bb Now open http:\/\/serverIP\/phpmyadmin in your browser. You can login using root as username and mysql root password.<\/p>\n","protected":false},"excerpt":{"rendered":"
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 \u2013 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/5694"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5694"}],"version-history":[{"count":1,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/5694\/revisions"}],"predecessor-version":[{"id":5695,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/5694\/revisions\/5695"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5694"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5694"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5694"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}