–nginx: Use the Nginx authenticator and installer Sudo certbot -nginx -agree-tos -redirect -hsts -staple-ocsp -must-staple -d -email your-email-address
#PHPMYADMIN UBUNTU NGINX INSTALL#
Now run the following command to obtain and install TLS certificate. Python3-certbot-nginx is the Nginx plugin for Certbot. Sudo apt install certbot python3-certbot-nginx Install the Let’s Encrypt client from Ubuntu 18.04 software repository like below: To secure the PHPMyAdmin web interface, we can install a free Let’s Encrypt TLS certificate. Before entering user credentials in the login form, let’s enable HTTPS. You can use Google Chrome to visit the phpMyAdmin web interface. Note that phpMyAdmin will not work in recent versions of Firefox. Now you should be able to access phpMyAdmin web interface via If the test is successful, reload Nginx for the changes to take effect. Your phpMyAdmin files are in /usr/share/phpmyadmin/ directory. Index index.php index.html index.htm Īccess_log /var/log/nginx/phpmyadmin_access.log Įrror_log /var/log/nginx/phpmyadmin_error.log įastcgi_pass unix:/run/php/ įastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name Replace with your actual sub-domain and don’t forget to create an A record for it. We will configure it so that we can access phpMyAdmin via a sub-domain. To be able to access the phpMyAdmin web interface, we need to create an Nginx server block by running the following command. Show grants for you can see, user PHPMyAdmin has all privileges on database PHPMyAdmin. You can use the following command to log into the MariaDB server.
If you are curious as I am, you can log into MariaDB and check what privileges PHPMyAdmin user has been granted. Once done, a new database named PHPMyAdmin is created and the database user PHPMyAdmin has necessary privileges to manage this database. Next, select Yes to create a new database and let dbconfig-common to configure it. Nginx isn’t in the list, so press the Tab key and hit OK to skip this step. The phpMyAdmin package is included in Ubuntu 18.04 software repository, so we can easily install it with the following command.ĭuring the installation, it will prompt you to select a web server to configure. I assumed that you have already installed Ubuntu 18.04 with Nginx, MariaDB and PHP7.4, if not, please check out this tutorial.
#PHPMYADMIN UBUNTU NGINX HOW TO#
This tutorial will be showing you how to install phpMyAdmin with two-factor authentication using Nginx, MariaDB and PHP7.4 on Ubuntu 18.04. In order to follow this guide, you should have a server with Ubuntu 18.04.4 LTS installed with 1GB minimal memory, 10GB minimal hard drive, access to sudo privileges, Nginx, MariaDB and PHP7.4.
0 kommentar(er)
