This tutorial is about How to get phpMyAdmin on Ubuntu 20.04 LTS. Recently I updated this tutorial and will try my best so that you understand this guide. I hope you guys like this blog, How to get phpMyAdmin on Ubuntu 20.04 LTS. If your answer is yes after reading the article, please share this article with your friends and family to support us.
Check How to get phpMyAdmin on Ubuntu 20.04 LTS
The best web-based client to access MySQL servers is phpMyadmin. It is available to download and install 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 compatible with 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 assume that you have already installed MySQL server on Ubuntu system. So just install the other packages needed to run and access phpMyAdmin.
sudo apt install apache2 wget unzip sudo apt install php php-zip php-json php-mbstring php-mysql
After 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 they mostly have an older version. In this tutorial, we will download the latest phpMyAdmin and configure it on our system.
Your system is ready for the installation of phpMyAdmin. Download the latest phpMyAdmin file from the official download page, or use the following commands to download phpMyAdmin 5.1.1 on your system.
After downloading, extract the file and move to the proper 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 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: adjust the firewall D
Firewall enabled systems must allow HTTP service from the firewall. Run the following commands 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 ready. You have finished the setup with phpMyAdmin on the Ubuntu Linux system. Now access phpMyAdmin with the server’s IP address or domain name.
http: // your-server-domain-ip / phpmyadmin
Replace your-server-ip-domain with the localhost (for local machines) or the system IP address for remote machines. I updated our DNS and pointed dbhost.tecadmin.net to the server’s IP address.
Login with the username and password used to access MySQL on the command line
Final remarks: How to get phpMyAdmin on Ubuntu 20.04 LTS
I hope you understand this article, How to get phpMyAdmin on Ubuntu 20.04 LTS. If your answer is no, you can ask anything via the contact forum section related to this article. And if your answer is yes, please share this article with your friends and family to give us your support.