Installing phpMyAdmin on Ubuntu 22.04

phpMyAdmin is a free and open-source tool written in PHP, designed to handle the administration of MySQL and MariaDB databases through a web browser. It allows users to manage databases, tables, fields, and execute SQL queries.

Step 1: Update the system

Before installing phpMyAdmin, it's always a good practice to update the system packages to the latest version.

sudo apt update
sudo apt upgrade -y

Step 2: Install Apache and PHP

phpMyAdmin requires a web server and PHP to function. Install Apache and PHP using the following command:

sudo apt install apache2 php libapache2-mod-php

Step 3: Install MariaDB

If you haven't already installed a MySQL or MariaDB server, you can install MariaDB using the following command:

sudo apt install mariadb-server

Step 4: Install phpMyAdmin

Now, install phpMyAdmin package using apt package manager:

sudo apt install phpmyadmin

During the installation, you will be prompted to choose the web server. Select "apache2" using the spacebar and press Enter.

Next, you will be asked to configure the database for phpMyAdmin. Choose "Yes" and set a password for the phpMyAdmin application.

Follow the on-screen instructions to complete the installation.

Step 5: Configure Apache

phpMyAdmin is installed, but we need to configure Apache to recognize and serve the application. Create a symbolic link for the phpMyAdmin installation:

sudo ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf-available/phpmyadmin.conf

Enable the configuration file and restart Apache:

sudo a2enconf phpmyadmin
sudo systemctl restart apache2

Step 6: Access phpMyAdmin

You can now access phpMyAdmin by visiting your server's IP address or domain name followed by /phpmyadmin in your web browser.

For example: http://your_domain_or_ip/phpmyadmin

Summary

By following these steps, you have successfully installed phpMyAdmin on Ubuntu 22.04. You can now use phpMyAdmin to manage your MySQL or MariaDB databases through a web interface.