Introduction

Phpmyadmin is graphical tool to manage Mysql database.It is hard to manage database throug cli for newbie.Phpmyadmin provides easy to use interface through which you can manage database operations like execute query,delete data base, column, rows etc import export database.

How to Install phpMyAdmin on CentOS 7

  1. Login to VPS Server using root or sudo user.
  2. Install Apache web server if it is not install
    yum install httpd -y <span id="mce_marker" data-mce-type="bookmark" data-mce-fragment="1">​</span>

    Next, we should make sure that Apache is running. Enter your server’s IP address into a browser address bar. You should see the Apache testing splash screen:

  3. Install the EPEL Respository
    yum install epel-release <span id="mce_marker" data-mce-type="bookmark" data-mce-fragment="1">​</span>
  4. Now install phpmyadmin on  centos 7
    yum install phpmyadmin <span id="mce_marker" data-mce-type="bookmark" data-mce-fragment="1">​</span>

     

  5. Configure the phpMyAdmin.conf file

The edit will make sure that you can access your phpMyAdmin client remotely. We’ll open the phpMyAdmin.conf file located in the directory /etc/httpd/conf.d/ using the vi editor:

vim /etc/httpd/conf.d/phpMyAdmin.conf

ere you will see four different require ip strings matched with long IPs. The default value is 127.0.0.1. Replace that value with the IP of the machine you will be using to access phpMyAdmin. You can use a tool like WhatsMyIP to check your IP. Save and exit the file by hitting escape and typing in :wq.

Restart the apache

systemctl restart httpd

Check if phpMyAdmin is Working

Finally, we can open phpMyAdmin utility by entering in your server’s IP address in a browser’s address bar with the addition /phpmyadmin string like so – 127.0.0.1/phpmyadmin. There you should see the login screen.

Locate Your phpMyAdmin Username and Password

Your username and password will be located in the file config.inc.php. The file will be in the phpMyAdmin installation directory. For us it is /etc/phpMyAdmin.

Open the file using the vi editor:

vi config.inc.php

 

Leave a Reply

Your email address will not be published. Required fields are marked *