MySQL notes

CREATE USER 'username'@'localhost' IDENTIFIED BY 'passwd';
DROP USER 'username'@'localhost';
CREATE DATABASE dbname;
GRANT ALL PRIVILEGES ON dbname.* TO 'username'@'localhost';
FLUSH PRIVILEGES; -- commit privileges cahnges
SELECT user, host FROM mysql.user;

mariabackup --backup --target-dir=some-backup --user=... --password=... 


rsync -avrP some-backup /var/lib/mysql-new/
chown -R mysql:mysql /var/lib/mysql-new/
rm /var/lib/mysql-new/ib_logfile*
systemctl stop mariadb
mv /var/lib/mysql /var/lib/mysql-old
mv /var/lib/mysql-new /var/lib/mysql
systemctl start mariadb