If you followed the prerequisite LAMP stack tutorial, several of these modules will have been installed along with the php package. Along with this package, the official documentation also recommends that you install a few PHP extensions onto your server to enable certain functionalities and improve performance. You can use APT to install phpMyAdmin from the default Ubuntu repositories.Īs your non-root sudo user, update your server’s package index:įollowing that you can install the phpmyadmin package. This will require you to register a domain name, create DNS records for your server, and set up an Apache Virtual Host.

If you do not have an existing domain configured with an SSL/TLS certificate, you can follow this guide on securing Apache with Let’s Encrypt on Ubuntu 20.04.

Executes and returns results for arbitrary SQL queriesįor these reasons, and because it is a widely-deployed PHP application which is frequently targeted for attack, you should never run phpMyAdmin on remote systems over a plain HTTP connection.

Handles authentication using MySQL credentials.

Communicates directly with your MySQL installation.

If this is not completed yet, you can follow this guide on installing a LAMP stack on Ubuntu 20.04.Īdditionally, there are important security considerations when using software like phpMyAdmin, since it:

A LAMP (Linux, Apache, MySQL, and PHP) stack installed on your Ubuntu 20.04 server.

To set this up, follow our initial server setup guide for Ubuntu 20.04. This server should have a non-root user with administrative privileges and a firewall configured with ufw. In order to complete this guide, you will need: In this guide, we’ll discuss how to install and secure phpMyAdmin so that you can safely use it to manage your databases on an Ubuntu 20.04 system. PhpMyAdmin was created so that users can interact with MySQL through a web interface.

While many users need the functionality of a database management system like MySQL, they may not feel comfortable interacting with the system solely from the MySQL prompt. An earlier version of this tutorial was written by Brennan Bearnes.

Install xampp ubuntu server