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.
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.
Now you can access PHPMyAdmin.
Open a browser and go to:
Thanks for visiting this page and Have a Good day. 🙂