How to Install PhpMyAdmin on CentOS 7.6

Installation Of phpMyAdmin On Centos 7.6

Purpose Of phpMyAdmin :

It is a tool used for administering MYSQL with a web browser.Typical operations such as the management of databases,tables,indexes,permissions and so on are executed with the user interface.Administrators can also use the phpMyAdmin to directly execute any sql statement.

Requirements:

LAMP Stack

Phpmyadmin configuration Location:

/etc/httpd/conf.d/phpmyadmin.conf

Install phpMyAdmin On CentOs 7.6 :

[root@linuxhelp ~]# yum install phpmyadmin -y
Loaded plugins: fastestmirror, langpacks
Loading mirror speeds from cached hostfile
 * base: centos.myfahim.com
 * epel: repos.del.extreme-ix.org
 * extras: centos.myfahim.com
 * remi-php72: mirror.reconn.ru
 * remi-safe: mirror.reconn.ru
 * updates: mirror.nbrc.ac.in
base                                                                                                                  | 3.6 kB  00:00:00     
Resolving Dependencies
--> Running transaction check
---> Package phpMyAdmin.noarch 0:4.4.15.10-3.el7 will be installed
--> Processing Dependency: php-php-gettext for package: phpMyAdmin-4.4.15.10-3.el7.noarch
--> Processing Dependency: php-tcpdf for package: phpMyAdmin-4.4.15.10-3.el7.noarch
--> Processing Dependency: php-tcpdf-dejavu-sans-fonts for package: phpMyAdmin-4.4.15.10-3.el7.noarch
--> Running transaction check
---> Package php-php-gettext.noarch 0:1.0.12-1.el7 will be installed
.
.
.
Installed:
  phpMyAdmin.noarch 0:4.4.15.10-3.el7                                                                                                        

Dependency Installed:
  libtidy.x86_64 0:5.4.0-1.el7                        php-bcmath.x86_64 0:7.2.17-1.el7.remi    php-fedora-autoloader.noarch 0:1.0.0-1.el7  
  php-php-gettext.noarch 0:1.0.12-1.el7               php-process.x86_64 0:7.2.17-1.el7.remi   php-tcpdf.noarch 0:6.2.26-1.el7             
  php-tcpdf-dejavu-sans-fonts.noarch 0:6.2.26-1.el7   php-tidy.x86_64 0:7.2.17-1.el7.remi     

Complete!

Go to the phpMyAdmin Configuration Location

[root@linuxhelp ~]# cd /etc/httpd/conf.d/

List the contents in the conf.d directory.

[root@linuxhelp conf.d]# ll
total 24
-rw-r--r-- 1 root root 2926 Nov  5 07:17 autoindex.conf
-rw-r--r-- 1 root root 1252 Apr  3 13:40 php.conf
-rw-r--r-- 1 root root 1779 May 26  2018 phpMyAdmin.conf
-rw-r--r-- 1 root root  366 Nov  5 07:17 README
-rw-r--r-- 1 root root 1252 Oct 30 20:30 userdir.conf
-rw-r--r-- 1 root root  824 Oct 30 20:30 welcome.conf

Log in to the MariaDB database with the root user and password.

[root@linuxhelp conf.d]# mysql -u root -p
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 19
Server version: 5.5.60-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


MariaDB [(none)]> exit
Bye

Restart the service Of Apache.

[root@linuxhelp conf.d]# systemctl restart httpd

Open the Browser and Enter the URL as follows: Enter the user and password of root to login to the MariaDB database The DashBoard of phpMyAdmin gets opened. Thus ,the installation Of phpMyAdmin comes to end on CentOS 7.6