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
Log in as root (Database admin) or DB user.
You will get the database page.
That’s All. Hope this helped you, we welcome your comments.
