Install phpMyAdmin on Ubuntu 22.04 with Apache

phpMyAdmin is a web-based application for interacting with MySQL database server. This tool provides you with a user interface to make MySQL operations so you don’t have to use the command line interface.

In this guide you are going to learn how to install phpMyAdmin with Apache on Ubuntu 22.04 and secure it.

Prerequisites

Make sure you have LAMP setup in your server with Apache, PHP and MySQL/MariaDB. If you don’t have the server setup you can follow the below guide to setup.
How to Install LAMP Apache, MySQL, PHP in Ubuntu 22.04

Install phpMyAdmin

Once you have your LAMP setup you can start by installing phpMyAdmin.

You might also like

How to Create a New systemd Service on Linux: A Step-by-Step Guide

3 months ago

How to List Groups in Linux: A Guide for Beginners

3 months ago

There are different ways to install phpMyAdmin, here we will follow the easiest way to install it.

Execute the below command to install phpMyAdmin.

sudo apt install phpmyadmin

In the prompt to choose web server, select Apache.

When prompted again to allow dbconfig-common to install a database and configure select Yes and press ENTER.

Then type and confirm a password or allow to use any random password.

Configure phpMyAdmin for Apache

Once phpMyAdmin is installed you can configure it with Apache so you can access the web interface.

Copy the phpmyadmin.conf from our installation to Apache’s conf-available directory.

sudo cp /etc/phpmyadmin/apache.conf /etc/apache2/conf-available/phpmyadmin.conf

Enable the configuration using a2enconf command.

sudo a2enconf phpmyadmin

Restart Apache for the changes to take effect.

sudo service apache2 restart

Now you can access phpMyAdmin using your domain followed by /phpmyadmin.

https://domain.com/phpmyadmin

Conclusion

Now you have learned how to install phpMyadmin on Ubuntu 22.04 with Apache.

Thanks for your time. If you face any problem or any feedback, please leave a comment below.