How to easily install PhpMyAdmin on Fedora 25 server. – DebYum

share on:
How to easily install PhpMyAdmin on Fedora 25 server. - DebYum

PhpMyAdmin is a free and open source tool written in PHP intended to handle the administration of MySQL or MariaDB with the use of a web browser. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; or managing users and permissions.

PhpMyAdmin provides the following features:

  • Web interface
  • MySQL and MariaDB database management
  • Import data from CSV and SQL
  • Export data to various formats.
  • Administering many servers
  • Creating PDF graphics of the database layout
  • Creating complex queries using Query-by-Example (QBE)
  • Searching globally in a database or a subset of it
  • Live charts to track MySQL server activity like connections, processes, CPU/Memory usage, etc.
  • Working with different operating systems.

Before we begin to install PhpMyAdmin on Fedora 25, you need to make sure you have LAMP installed on Fedora 25. If you haven’t installed LAMP stack on Fedora 25 yet then you can follow this easy tutorial to install LAMP on your Fedora 25 server.

How to install latest LAMP stack on Fedora 25.

If you have already installed LAMP on fedora 25 then follow these steps.

 

Install PhpMyAdmin on Fedora 25.

Check the status of Apache server.

 

Check the status of MariaDB server.

 

Check the version of PHP installed on your server.

 

Search for the PhpMyAdmin package in Fedora package repositories.

 

Install PhpMyAdmin on Fedora 25 server.

[engy@fedora ~]$ sudo dnf install phpmyadmin -y

 

Allow remote access to PhpMyAdmin in Fedora 25.

Edit the /etc/httpd/conf.d/phpMyAdmin.conf file to allow remote access for PhpMyAdmin.

As we are using Apache 2.4, we will edit only the section of the file about Apache version 2.4.

[engy@fedora ~]$ sudo vi /etc/httpd/conf.d/phpMyAdmin.conf

 

 

If you want to allow access from a specific IP only then you should replace the Require ip 127.0.0.1 with the specific IP. For example to allow Ip address 192.168.0.111 then we will use this statement.

Require ip 192.168.0.111

To further security harden you PHP Application, you can follow this article.

Top 10 PHP Security best practices for Linux sys administrators.

 

Now you can access PHPMyAdmin.

Open a browser and go to:

http://<server-ip-adress>/phpmyadmin

 

 

phpmyadmin on fedora

 

Thanks for visiting this page and Have a Good day. 🙂

share on:
engy

engy

Hello there, My name is Rishi Guleria and I work as a Linux system administrator. I have created this blog to share what I have learned so far and to learn new things. Good Day. :)

Leave a Response

share on: