FedoraRHEL Based

How To Install phpMyAdmin on Fedora 39

Install phpMyAdmin on Fedora 39

In this tutorial, we will show you how to install phpMyAdmin on Fedora 39. phpMyAdmin is a free and open-source tool written in PHP, designed to handle the administration of MySQL and MariaDB over the Web. It provides a user-friendly graphical interface to perform various database operations, including managing databases, tables, columns, relations, indexes, users, permissions, and executing SQL statements.

This article assumes you have at least basic knowledge of Linux, know how to use the shell, and most importantly, you host your site on your own VPS. The installation is quite simple and assumes you are running in the root account, if not you may need to add ‘sudo‘ to the commands to get root privileges. I will show you the step-by-step installation of the phpMyAdmin on a Fedora 39.

Prerequisites

Before diving into the installation process, let’s ensure that you have everything you need:

  • A server running one of the following operating systems: Fedora 39.
  • It’s recommended that you use a fresh OS install to prevent any potential issues.
  • You will need access to the terminal to execute commands. Fedora 39 provides the Terminal application for this purpose. It can be found in your Applications menu.
  • You’ll need an active internet connection to download phpMyAdmin and its dependencies.
  • A non-root sudo user or access to the root user. We recommend acting as a non-root sudo user, however, as you can harm your system if you’re not careful when acting as the root.

Install phpMyAdmin on Fedora 39

Step 1. First, it’s always a good practice to update your system packages to their latest versions. Open your terminal and execute the following command:

sudo dnf clean all
sudo dnf update

Step 2. Installing Apache.

Apache is a popular open-source web server that we’ll use to serve our phpMyAdmin interface. To install Apache, run the following command:

sudo dnf install httpd

Once installed, start the Apache service and enable it to run at system startup using:

sudo systemctl start httpd
sudo systemctl enable httpd

Step 3. Installing PHP.

phpMyAdmin is written in PHP, so we need to install PHP and some necessary extensions. Execute the following command:

sudo dnf install php php-mbstring php-mysqlnd

Step 4. Installing MariaDB.

MariaDB is a fork of MySQL and one of the most popular open-source databases. Install it using:

sudo dnf install mariadb-server

Start and enable MariaDB with:

sudo systemctl start mariadb
sudo systemctl enable mariadb

Securing your MariaDB installation is crucial to protect your data. Run the security script that comes with MariaDB:

sudo mysql_secure_installation

Follow the prompts to set a root password, remove anonymous users, disallow root login remotely, and remove test databases.

Step 6. Install phpMyAdmin on Fedora 39.

We’ll install phpMyAdmin from the Remi repository, which maintains updated PHP packages. First, add the Remi repository:

sudo dnf install https://rpms.remirepo.net/fedora/remi-release-39.rpm

Next, install phpMyAdmin:

sudo dnf --enablerepo=remi install phpmyadmin

Step 7. Configure Apache for phpMyAdmin

Apache needs to be configured to serve the phpMyAdmin interface. Edit the Apache configuration file for phpMyAdmin:

sudo nano /etc/httpd/conf.d/phpMyAdmin.conf

Ensure the configuration allows connections from your IP address. Save and close the file, then restart Apache:

sudo systemctl restart httpd

Step 8. Accessing phpMyAdmin Web UI.

Once successfully installed, You can now access phpMyAdmin by opening a web browser and navigating to http://your_server_ip/phpmyadmin. Use the MariaDB credentials you set earlier to log in.

Install phpMyAdmin on Fedora 39

Congratulations! You have successfully installed phpMyAdmin. Thanks for using this tutorial for installing the phpMyAdmin on your Fedora 39 system. For additional or useful information, we recommend you check the official phpMyAdmin website.

VPS Manage Service Offer
If you don’t have time to do all of this stuff, or if this is not your area of expertise, we offer a service to do “VPS Manage Service Offer”, starting from $10 (Paypal payment). Please contact us to get the best deal!

r00t

r00t is a seasoned Linux system administrator with a wealth of experience in the field. Known for his contributions to idroot.us, r00t has authored numerous tutorials and guides, helping users navigate the complexities of Linux systems. His expertise spans across various Linux distributions, including Ubuntu, CentOS, and Debian. r00t's work is characterized by his ability to simplify complex concepts, making Linux more accessible to users of all skill levels. His dedication to the Linux community and his commitment to sharing knowledge makes him a respected figure in the field.
Back to top button