MariaDB

EASY BACKUP

1.
$ mysqldump -u root -p –all-databases > db.sql
$ mysql -u root -p db < db.sql
$ du -sh db.sql

2. 
$ dnf -y install mariadb-backup 
$ mariabackup --backup --target-dir /home/backup -u root -p password 

SYSTEMCTL MARIADB

$ systemctl stop mariadb 
$ systemctl start mariadb 
$ systemctl restart mariadb 

INIT SECURE DB

$ mysql_secure_installation

CREATE NEW USER|GRANT ALL PRIVILEGES

mysql> CREATE USER 'newuser'@'%' IDENTIFIED BY 'password'; 
mysql> CREATE USER 'newuser'@'[IP|DOMAIN]' IDENTIFIED BY 'password'; 
mysql> CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password'; 

mysql> GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost'; 
mysql> FLUSH PRIVILEGES;