How To Install MySQL 8 On Ubuntu 18.04

mysql 8 in ubuntu

In this article, we learn how to install and initially configure MySql 8.0 Server on Ubuntu 18.04 LTS Server. Mysql is one of the most used and famous Relational Database Server available on the internet because It is very reliable and secure and also it’s easy to learn and operate it. MySql uses SQL “Structured … 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

Backup all MySQL Databases with a MySQL Backup Script

MySQL-Logo

In this article, we will create a simple MySQL backup script for taking backups of all your MySQL databases periodically. If your website or web app runs over a LAMP stack or you’re running a Linux OS whether it is Ubuntu or Centos, you can write a simple script for taking MySQL backups at a … Read more