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
TAB, and then
ENTER to select Apache.
Yes at prompt
dbconfig-common to set up the database.
Now we choose and confirm a MySQL application password for phpMyAdmin.
You can now access the web interface by visiting your server’s domain name or public IP address followed by
Log in to the user interface, either as root or with the new username and password configured.
When you log in, you’ll see the user interface of phpMyAdmin, which will look something like this:
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.
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.