Install and Secure phpMyAdmin with Nginx on Ubuntu 18.04

phpMyAdmin-with-Nginx-on-Ubuntu-18.04-ftrd-img

In this tutorial, we learn how to Install and Secure phpMyAdmin with Nginx on Ubuntu 18.04. phpMyAdmin is the most used free graphical interface for Mysql and MariaDB operations. phpMyAdmin having a wide range of operations on MySQL and MariaDB. If you do not like the command-line interface then you should try is once. Prerequisites … Read more

Creating a backup user with read-only permission for MySQL DB

mysql-backup-user-poster

Why do we need to create a user with read-only permission? Most people use “mysqldump” for taking the backup of MySQL. And when we automate the backup process the password of the user is saved in a file (Ex. script or mysql.inf ). If our backup user is a superuser and something went wrong in … Read more