phpMyAdmin installation on CentOS 7/RHEL 7

2
515

phpMyAdmin

phpMyAdmin is a popular Web-based tool for administration of the MySQL and MariaDB. It is the free and open-source tool developed by using PHP. It will be used for creating, modifying and deleting databases, tables, views etc. We can also use it to executing SQL commands, Managing users, and their permissions. It works with various operating systems like windows, Linux etc.

Before we going to start the installation of phpMyAdmin, Make sure that System is Up to Date and Lamp stack is installed.

#yum -y update

LAMP Stack installation on Linux

phpMyAdmin is not available in default Repositories, so we have to add and enable EPEL repo.

#yum -y install epel-release
#yum -y install phpmyadmin
Loaded plugins: fastestmirror, langpacks
Resolving Dependencies
--> Running transaction check
---> Package phpMyAdmin.noarch 0:4.4.15.9-1.el7 will be installed
--> Processing Dependency: php-tcpdf-dejavu-sans-fonts for package: phpMyAdmin-4                                                                                        .4.15.9-1.el7.noarch
--> Processing Dependency: php-tcpdf for package: phpMyAdmin-4.4.15.9-1.el7.noar                                                                                        ch
--> Processing Dependency: php-php-gettext for package: phpMyAdmin-4.4.15.9-1.el                                                                                        7.noarch
--> Running transaction check
---> Package php-php-gettext.noarch 0:1.0.12-1.el7 will be installed
---> Package php-tcpdf.noarch 0:6.2.13-1.el7 will be installed
--> Processing Dependency: php-tidy for package: php-tcpdf-6.2.13-1.el7.noarch
--> Processing Dependency: php-posix for package: php-tcpdf-6.2.13-1.el7.noarch
--> Processing Dependency: php-composer(fedora/autoloader) for package: php-tcpdf-6.2.13-1.el7.noarch
---> Package php-tcpdf-dejavu-sans-fonts.noarch 0:6.2.13-1.el7 will be installed
--> Running transaction check
---> Package php-fedora-autoloader.noarch 0:0.2.1-2.el7 will be installed
---> Package php-process.x86_64 0:5.4.16-42.el7 will be installed
---> Package php-tidy.x86_64 0:5.4.16-7.el7 will be installed
--> Processing Dependency: libtidy-0.99.so.0()(64bit) for package: php-tidy-5.4.16-7.el7.x86_64
--> Running transaction check
---> Package libtidy.x86_64 0:0.99.0-31.20091203.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

========================================================================================================================================================================
 Package                                             Arch                           Version                                          Repository                    Size
========================================================================================================================================================================
Installing:
 phpMyAdmin                                          noarch                         4.4.15.9-1.el7                                   epel                         4.7 M
Installing for dependencies:
 libtidy                                             x86_64                         0.99.0-31.20091203.el7                           epel                         132 k
 php-fedora-autoloader                               noarch                         0.2.1-2.el7                                      epel                         9.0 k
 php-php-gettext                                     noarch                         1.0.12-1.el7                                     epel                          23 k
 php-process                                         x86_64                         5.4.16-42.el7                                    base                          55 k
 php-tcpdf                                           noarch                         6.2.13-1.el7                                     epel                         2.1 M
 php-tcpdf-dejavu-sans-fonts                         noarch                         6.2.13-1.el7                                     epel                         257 k
 php-tidy                                            x86_64                         5.4.16-7.el7                                     epel                          23 k

Transaction Summary
========================================================================================================================================================================
Install  1 Package (+7 Dependent packages)

Total download size: 7.2 M
Installed size: 37 M
Downloading packages:
(1/8): php-php-gettext-1.0.12-1.el7.noarch.rpm                                                                                                   |  23 kB  00:00:01
(2/8): php-process-5.4.16-42.el7.x86_64.rpm                                                                                                      |  55 kB  00:00:07
(3/8): php-tidy-5.4.16-7.el7.x86_64.rpm                                                                                                          |  23 kB  00:00:05
php-fedora-autoloader-0.2.1-2. FAILED                                                                                                 ]  19 kB/s | 299 kB  00:06:18 ETA
http://epel.scopesky.iq/7/x86_64/p/php-fedora-autoloader-0.2.1-2.el7.noarch.rpm: [Errno 14] curl#6 - "Could not resolve host: epel.scopesky.iq; Name or service not known"
Trying other mirror.
(4/8): libtidy-0.99.0-31.20091203.el7.x86_64.rpm                                                                                                 | 132 kB  00:00:38
(5/8): php-tcpdf-dejavu-sans-fonts-6.2.13-1.el7.noarch.rpm                                                                                       | 257 kB  00:00:49
(6/8): php-tcpdf-6.2.13-1.el7.noarch.rpm                                                                                                         | 2.1 MB  00:02:26
(7/8): phpMyAdmin-4.4.15.9-1.el7.noarch.rpm                                                                                                      | 4.7 MB  00:08:04
(8/8): php-fedora-autoloader-0.2.1-2.el7.noarch.rpm                                                                                              | 9.0 kB  00:00:01
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                                    14 kB/s | 7.2 MB  00:08:45
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : php-php-gettext-1.0.12-1.el7.noarch                                                                                                                  1/8
  Installing : php-fedora-autoloader-0.2.1-2.el7.noarch                                                                                                             2/8
  Installing : php-process-5.4.16-42.el7.x86_64                                                                                                                     3/8
  Installing : libtidy-0.99.0-31.20091203.el7.x86_64                                                                                                                4/8
  Installing : php-tidy-5.4.16-7.el7.x86_64                                                                                                                         5/8
  Installing : php-tcpdf-6.2.13-1.el7.noarch                                                                                                                        6/8
  Installing : php-tcpdf-dejavu-sans-fonts-6.2.13-1.el7.noarch                                                                                                      7/8
  Installing : phpMyAdmin-4.4.15.9-1.el7.noarch                                                                                                                     8/8
  Verifying  : php-tcpdf-6.2.13-1.el7.noarch                                                                                                                        1/8
  Verifying  : php-tcpdf-dejavu-sans-fonts-6.2.13-1.el7.noarch                                                                                                      2/8
  Verifying  : libtidy-0.99.0-31.20091203.el7.x86_64                                                                                                                3/8
  Verifying  : php-process-5.4.16-42.el7.x86_64                                                                                                                     4/8
  Verifying  : php-fedora-autoloader-0.2.1-2.el7.noarch                                                                                                             5/8
  Verifying  : php-php-gettext-1.0.12-1.el7.noarch                                                                                                                  6/8
  Verifying  : php-tidy-5.4.16-7.el7.x86_64                                                                                                                         7/8
  Verifying  : phpMyAdmin-4.4.15.9-1.el7.noarch                                                                                                                     8/8

Installed:
  phpMyAdmin.noarch 0:4.4.15.9-1.el7

Dependency Installed:
  libtidy.x86_64 0:0.99.0-31.20091203.el7  php-fedora-autoloader.noarch 0:0.2.1-2.el7         php-php-gettext.noarch 0:1.0.12-1.el7  php-process.x86_64 0:5.4.16-42.el7
  php-tcpdf.noarch 0:6.2.13-1.el7          php-tcpdf-dejavu-sans-fonts.noarch 0:6.2.13-1.el7  php-tidy.x86_64 0:5.4.16-7.el7

Complete!
[root@localhost ~]#

Now edit the configuration file /etc/httpd/conf.d/phpMyAdmin.conf file and add the host from which we are accessing phpmyadmin web console.

Once the editing completes restart the httpd service and access it by using The URL address http://ip-address/phpMyAdmin. The login window  is as follows

Login with Mariadb username and passwords. The Dashboard is as follows

Enjoy PhpMyAdmin in your System. Explore all the options available to master the application.

 

2 COMMENTS