Linux, Windows, Virtualization, OpenSource & Blogging

Install phpMyAdmin on Fedora 26 / Fedora 25

0

phpMyAdmin
phpMyAdmin is the web-based administration tool for managing the MySQL, MariaDB and Drizzle servers; it helps in performing databases activities such as creating, deleting, querying , tables, columns, relations, indexes, users, permissions, etc. This guide will help you to install phpMyAdmin on Fedora 21.

Before installing phpMyAdmin, you must have LAMP installed on the server. Here is the tutorial on Installing LAMP on Fedora 26.

Install phpMyAdmin

Install phpMyAdmin using the following command.

yum -y install phpmyadmin

Configure phpMyAdmin

By-default phpMyAdmin places the web config file in /etc/httpd/conf.d directory; it has the rules and access permission. phpMyAdmin can be accessed only from the localhost, to change that; we have to edit the phpMyadmin.conf file.

In Fedora 21, web access is managed by the mod_authz_core.c module; so normal allow or deny rules won’t work even if you modify.

vi /etc/httpd/conf.d/phpMyAdmin.conf

Default config will look like below.

Alias /phpMyAdmin /usr/share/phpMyAdmin
Alias /phpmyadmin /usr/share/phpMyAdmin

<Directory /usr/share/phpMyAdmin/>
   AddDefaultCharset UTF-8

   <IfModule mod_authz_core.c>
     # Apache 2.4
     <RequireAny>
       Require ip 127.0.0.1
       Require ip ::1
     </RequireAny>
   </IfModule>
   <IfModule !mod_authz_core.c>
     # Apache 2.2
     Order Deny,Allow
     Deny from All
     Allow from 127.0.0.1
     Allow from ::1
   </IfModule>
</Directory>

<Directory /usr/share/phpMyAdmin/setup/>
   <IfModule mod_authz_core.c>
     # Apache 2.4
     <RequireAny>
       Require ip 127.0.0.1
       Require ip ::1
     </RequireAny>
   </IfModule>
   <IfModule !mod_authz_core.c>
     # Apache 2.2
     Order Deny,Allow
     Deny from All
     Allow from 127.0.0.1
     Allow from ::1
   </IfModule>
</Directory>

Please comment out Require ip 127.0.0.1 and Require ip ::1 then add Require all granted just below to commented line. It will look like below.

Alias /phpMyAdmin /usr/share/phpMyAdmin
Alias /phpmyadmin /usr/share/phpMyAdmin

<Directory /usr/share/phpMyAdmin/>
   AddDefaultCharset UTF-8

   <IfModule mod_authz_core.c>
     # Apache 2.4
     <RequireAny>
       #Require ip 127.0.0.1
       #Require ip ::1
       Require all granted
     </RequireAny>
   </IfModule>
   <IfModule !mod_authz_core.c>
     # Apache 2.2
     Order Deny,Allow
     Deny from All
     Allow from 127.0.0.1
     Allow from ::1
   </IfModule>
</Directory>

<Directory /usr/share/phpMyAdmin/setup/>
   <IfModule mod_authz_core.c>
     # Apache 2.4
     <RequireAny>
       #Require ip 127.0.0.1
       #Require ip ::1
       Require all granted
     </RequireAny>
   </IfModule>
   <IfModule !mod_authz_core.c>
     # Apache 2.2
     Order Deny,Allow
     Deny from All
     Allow from 127.0.0.1
     Allow from ::1
   </IfModule>
</Directory>

Restart the apache service.

systemctl reload httpd.service

Configure the firewall to allow HTTP request from the external network.

firewall-cmd --permanent --zone=public --add-service=http
firewall-cmd --reload

Access phpMyAdmin

Now access the phpMyAdmin from the browser, URL will be

http://your-ip-address/phpMyAdmin

Log in as root (Database admin) or DB user.

Install phpMyAdmin on Fedora 26 - phpMyadmin Login Page
Install phpMyAdmin on Fedora 26 – phpMyadmin Login Page

You will get the database page.

Install phpMyAdmin on Fedora 26 - phpMyAdmin Home Page
Install phpMyAdmin on Fedora 26 – phpMyAdmin Home Page

That’s All. Hope this helped you, we welcome your comments.

POSTS YOU MAY LIKE -:)

You might also like

Install phpMyAdmin on Fedora 26 / Fedora 25

0