Install phpMyAdmin on Fedora 27 / Fedora 26/25/24

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 27 / Fedora 26/25.

Install phpMyAdmin

Install phpMyAdmin using the following command.

dnf -y install phpmyadmin httpd

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, 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 restart httpd

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

firewall-cmd --permanent --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.

You might also like