How to Install phpMyAdmin on CentOS 7?

phpMyAdmin is a web-based GUI tool to manage your MySQL and MariaDB Databases. It is an Open-source and free tool. Following are the steps to install phpMyAdmin on Centos 7.

  1. We will install EPEL repository first because cPanel doesn't have access to phpMyAdmin within its software repository By Default.

    #sudo yum install -y epel-release
  2. Install the Apache server with the below command.

    # sudo yum install httpd -y
  3. Start the Apache Server.

    # systemctl start httpd
  4. Install phpMyAdmin with below command.

    # sudo yum -y install phpmyadmin
  5. Let's modify the phpMyAdmin config file to allow only specific IP Addresses. This file should be created automatically while installing phpMyAdmin.

  6. Open phpMyAdmin.conf file.

    # sudo nano /etc/httpd/conf.d/phpMyAdmin.conf


  7. Start the Apache Server.

    # systemctl start httpd
  8. Edit the Require ip 127.0.0.1 with your local connection IP Address. There might be four-place were in the same file where you need to set your IP address in place of 127.0.0.1. Click here to view your Ip Address.

  9. Save and Close the phpMyAdmin.conf

  10. Restart the Apache.

  11. Open the phpMyAdmin in your browser with the serverip/phpmyadmin.

  12. You can locate the phpMyAdmin Username and Password from config.inc.php located at /etc/phpMyAdmin

  13. Open it with the vi editor.

$cfg['Servers'][$i]['auth_type'] = 'cookie';
)?
$cfg['Servers'][$i]['user'] = 'username';
$cfg['Servers'][$i]['password'] = 'password';
$cfg['Servers'][$i]['only_db'] = '';
  1. Save this file with :wq

Now, you can log in to your phpMyAdmin using the same credentials.

  • 0 Users Found This Useful

Was this answer helpful?

Related Articles

How to install the Zabbix agent version 4.0 on Debian 9 (strech)?

Zabbix is an Open-source monitoring tool use to monitor the health of servers, networks and other...

How to sync time using NTP in Ubuntu server?

Linux server users might have noticed that after adjusting the system clock to the correct time,...

Will internal traffic between two VPS viz. a Database Server and a Web Server be counted in my bandwidth usage?

Yes it will. The traffic will be counted in the bandwidth usage of your VPS. Even if you use...

How to install Google Chrome on Ubuntu 18.04 using the Command Line?

Following are the steps to install Google Chrome using Command-Line. Edit the source.list file...

Can I upgrade my VPS plan without losing any data or settings?

Yes, you can upgrade your existing VPS to higher plan anytime. Your data will remain intact. We...