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.
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.
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 )
# Apache 2.4 <RequireAny> Require ip 127.0.0.1 Require ip ::1 </RequireAny>
Replace with
# Apache 2.4 <RequireAny> # Require ip 127.0.0.1 # Require ip ::1 Require all granted </RequireAny>
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.
That’s it . Have a nice day.
Visual Studio Code is a popular code editor which is lightweight and cross platform application.…
MySQL workbench is a GUI tool for managing MySQL database system. It is used by…
Android Studio is a popular development software used especially for developing android applications. It is…
Google chrome is a most popular web browser developed by google. It was developed to…
Zoom is a popular video conferencing software. It is commonly used for conducting online meetings,…
TeamViewer is a popular application for desktop sharing and remote control. It is available for…