This article covers how to Install phpMyAdmin with Nginx on Ubuntu 18.04 system. When developing a website or web application, many users need the functionality of a database system like MySQL. However, interacting with the system solely from the MySQL command-line client requires familiarity with Structured Query Language — more commonly referred to as SQL — which can present a major hurdle for some users. phpMyAdmin was created to allow users to interact with MySQL through an intuitive web interface, running alongside a PHP development environment.
How to Secure phpMyAdmin with Let's Encrypt SSL ?
Before starting, you will need to install the Certbot client to download and install Let's Encrypt SSL.
1. First, add the Certbot repository with the following command:
$ add-apt-repository ppa:ahasenack/certbot-tlssni01-1875471
2. Next, update the repository and install the Certbot client using the following command:
$ apt-get update -y
$ apt-get install certbot python3-certbot-nginx -y
3. Once the Certbot has been installed, run the following command to download and install the Let's Encrypt SSL for your domain:
$ certbot --nginx -d phpmyadmin.domain.com