phpMyAdmin is a free and open-source web-based administration tool for managing MySQL and MariaDB databases. It provides an easy-to-use graphical interface for managing and administering your databases. In this tutorial, we will guide you through the steps to install phpMyAdmin on your server.
Before we begin, ensure that you have a LAMP stack installed on your server. This includes Apache, MySQL/MariaDB, and PHP. If you do not have a LAMP stack installed, follow our guide on how to install LAMP stack on Ubuntu 20.04.
Step 1: Install phpMyAdmin
To install phpMyAdmin, open your terminal and run the following command:
sudo apt-get update
sudo apt-get install phpmyadmin
During the installation process, you will be prompted to choose the web server that you are using. In our case, we will select Apache by pressing the spacebar and then pressing enter. After that, you will be prompted to configure the database for phpMyAdmin. You can choose to configure it later, but for this tutorial, we will select Yes.
After the installation is complete, you need to enable the phpMyAdmin Apache module. To do this, run the following command:
sudo ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf-available/phpmyadmin.conf
sudo a2enconf phpmyadmin.conf
sudo systemctl restart apache2
Step 2: Configure phpMyAdmin
After the installation is complete, you need to configure phpMyAdmin to work with your MySQL/MariaDB database. To do this, open the configuration file using your favorite text editor:
sudo nano /etc/phpmyadmin/config.inc.php
Find the following lines in the file:
$cfg[‘Servers’][$i][‘auth_type’] = ‘cookie’;
$cfg[‘Servers’][$i][‘host’] = ‘localhost’;
Replace ‘localhost’ with your server’s IP address or hostname. If you want to connect to a remote MySQL/MariaDB server, replace ‘localhost’ with the IP address or hostname of the remote server.
Save and close the file.
Step 3: Accessing phpMyAdmin
After the installation and configuration are complete, you can access phpMyAdmin by visiting http://your-server-ip-address/phpmyadmin/ in your web browser. Enter your MySQL/MariaDB database username and password, and you will be logged in.
In this tutorial, we have shown you how to install and configure phpMyAdmin on Ubuntu 20.04. With phpMyAdmin, you can easily manage and administer your MySQL/MariaDB databases using a web-based graphical interface. If you have any issues or questions, feel free to leave a comment below.