In this guide, we will Install phpMyAdmin on Ubuntu server. While many users need the functionality of a database management system like MySQL, they may not feel comfortable interacting with the MySQL CLI (Command-Line Interface), to simplify this we use phpMyAdmin as GUI (Graphical User Interface).

For that first we need to install LAMP stack on your Ubuntu server. If this is not completed yet, you can follow the LAMP stack installation guide on how to install LAMP stack on Ubuntu server.

Once you are finished with LAMP stack installation, you’re ready to get started with this phpMyAdmin installation guide.

Install phpMyAdmin On Ubuntu Server

sudo apt-get update
sudo apt-get install phpmyadmin

This will ask you a few questions in order to configure your installation correctly.

Now we select “Apache2” which highlighted but not selected. If you do not hit SPACE to select “Apache”, the installer will not move the necessary files during installation. Hit SPACETAB, and then ENTER to select Apache.

apache2 not selected
hit SPACE to select “Apache”

Now select Yes at prompt dbconfig-common to set up the database.

Installation process prompt type yes for phpMyAdmin On Ubuntu

Now we choose and confirm a MySQL application password for phpMyAdmin.

Installation process password confirmation for phpMyAdmin On Ubuntu
Installation process password confirmation for phpMyAdmin On Ubuntu

You can now access the web interface by visiting your server’s domain name or public IP address followed by /phpmyadmin

Log in to the user interface, either as root or with the new username and password configured.

phpMyAdmin login page

When you log in, you’ll see the user interface of phpMyAdmin, which will look something like this:

successfully phpMyAdmin installed On Ubuntu

Now you’re able to connect and interact with phpMyAdmin user interface. Using this interface, you can easily create databases, users, tables, etc., and perform the usual operations like deleting and modifying structures and data.

Conclusion:

Now that you have Installed phpMyAdmin on LAMP stack, you can now manage MySQL with web browser. Typical operations such as the management of databases, tables, indexes, permissions, and so on are executed with the user interface.

Hope this tutorial is helpful and comment down if you have any query or issue.