How To Install and Configure phpMyAdmin on Fedora 23

Posted on by dpepper
Reading Time: 2 minutes

PhpMyAdmin is an open-source tool used for the administration of MySQL. In addition to offering the capability to perform administrative tasks such as creating, editing, or deleting databases, and managing users and permissions, PhpMyAdmin provides a graphical user interface to do all of these tasks and more.

Pre-Flight Check

  • These instructions are intended for installing PhpMyAdmin on Fedora 23. If you’re using a different operating system, check out our guides to installing PhpMyAdmin on Fedora 22, Ubuntu 15.04, CentOS 6 and CentOS 7.
  • For this tutorial, we’ll be using a Liquid Web Self Managed Fedora 23 server and logging in as root.
    A LAMP stack (Linux, Apache, MySQL and PHP) must be installed on your server.

Step #1: Install PhpMyAdmin

First, we’ll follow best practices and ensure that the list of available packages is up to date:

dnf -y update

Then it’s a matter of running one command for installation:

dnf -y install phpmyadmin

Step #2: Find Your IP Address

You can determine your public IP address by visiting the site.

Step #3: Basic Configuration for PhpMyAdmin

By default, the configuration for PhpMyAdmin allows access only from the server on which it is installed. To be able to access PhpMyAdmin’s web interface from your IP address, we’ll edit the Apache Virtual Host file created automatically during installation.

vim /etc/httpd/conf.d/phpMyAdmin.conf

For a refresher on editing files with vim, see New User Tutorial: Overview of the Vim Text Editor. If vim is not installed on your OS, you can follow our tutorial on installing vim at How to Install VIM (Visual editor IMproved) on Fedora 23.

In the PhpMyAdmin.conf, locate the following sections and change each IP address to the one you found in Step 2 (there should be a total of four instances of “” which you’ll need to change to your IP address):

Require ip
Allow from
Require ip
Allow from

Then save and exit the file with the following command:


Now, restart Apache:

systemctl restart httpd

Verify that PhpMyAdmin is working by visiting http://the_IP_of_your_server/phpmyadmin. For example: http://111.222.333.444/phpmyadmin.

Learn More

To create a database user, visit Create a MySQL User on Linux via Command Line.
To grant permissions to a database user, visit Grant Permission to a MySQL User on Linux via Command Line.

Avatar for dpepper

About the Author: dpepper

Latest Articles

What is Bare Metal Programming?

Read Article

Useful Features in cPanel for Your Sites

Read Article

How to Clone a Drupal Site to Another Domain

Read Article

Accessing Man Pages on Ubuntu 16.04 LTS

Read Article

What is VMware Fusion?

Read Article