How to get phpMyAdmin on Ubuntu 20.04 LTS

This tip is about the how to get phpMyAdmin on Ubuntu 20.04 LTS. So read this free guide, How to get phpMyAdmin on Ubuntu 20.04 LTS step by step. If you have query related to same article you may contact us.

How to get phpMyAdmin on Ubuntu 20.04 LTS – Guide

The best web-based client for accessing MySQL servers is phpMyadmin. It is available for download and installation on your server at no cost. This can be hosted on any server that supports Apache and PHP.

PHP is used to create phpMyAdmin. PHP 7.1 and later, as well as MySQL 5.5 or MariaDB 5.5 or later, are supported by the current version of phpMyAdmin.

This guide will show you how to install and configure phpMyAdmin on a Linux system running Ubuntu 20.04.

Step 1 – Install Apache and PHP

We are assuming that you have already installed MySQL server on Ubuntu system. So, just install the other packages needed to run and access phpMyAdmin.

sudo to install apache2 wget unzip sudo to install php php-zip php-json php-mbstring php-mysql

Once the installation is complete, enable and start the Apache web server.

sudo systemctl enable apache2 sudo systemctl start apache2

Step 2 – Install phpMyAdmin on Ubuntu 20.04

phpMyAdmin is also available in the default package repository, but most of them have an older version. In that tutorial, we will download the latest phpMyAdmin and configuration to our system.

Your system is now ready to install phpMyAdmin. Download the latest phpMyAdmin file from the official download page or use the commands below to download phpMyAdmin 5.1.1 to your system.

After downloading, extract the file and go to the appropriate location.

wget https://files.phpmyadmin.net/phpMyAdmin/5.1.1/phpMyAdmin-5.1.1-all-languages.zip unzip phpMyAdmin-5.1.1-all-languages.zip mv phpMyAdmin-5.1.1-all-languages / usr / share / phpmyadmin

Then create the tmp directory and set the appropriate permissions.

mkdir / usr / share / phpmyadmin / tmp chown -R www-data: www-data / usr / share / phpmyadmin chmod 777 / usr / share / phpmyadmin / tmp

Step 3 – Configure phpMyAdmin

Now, you need to configure the web server to serve phpMyAdmin on the network. Create the Apache configuration file for phpMyAdmin and edit it in the text editor:

sudo vi /etc/apache/conf-available/phpmyadmin.conf

Step 4 – Adjusting FirewallD

Systems with enabled firewalls must allow the firewall’s HTTP service. Run the commands below to open a port for the web server on the firewall.

sudo firewall-cmd –permanent –add-service = http sudo firewall-cmd –reload

Step 5 – Access phpMyAdmin

All done. You have completed the setup with phpMyAdmin on the Ubuntu Linux system. Now access phpMyAdmin with the server IP address or domain name.

http: // your-server-ip-domain / phpmyadmin

Replace your-server-ip-domain with localhost (for local machines) or your system IP address for remote machines. I updated our DNS and pointed dbhost.tecadmin.net to the server’s IP address.

Log in with the username and password used to access MySQL from the command line

Final note

I hope you like the guide How to get phpMyAdmin on Ubuntu 20.04 LTS. In case if you have any query regards this article you may ask us. Also, please share your love by sharing this article with your friends.