Установка mariadb

sudo apt update
sudo apt upgrade -y

sudo apt install mariadb-server -y

sudo systemctl status mariadb

sudo systemctl start mariadb

sudo systemctl enable mariadb

sudo mysql_secure_installation

sudo mysql

CREATE DATABASE mydb CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE USER ‘myuser’@’localhost’ IDENTIFIED BY ‘mypassword’;
GRANT ALL PRIVILEGES ON mydb.* TO ‘myuser’@’localhost’;
FLUSH PRIVILEGES;

GRANT CREATE, CREATE USER ON *.* TO ‘myuser’@’localhost’;
FLUSH PRIVILEGES;

GRANT ALL PRIVILEGES ON *.* TO ‘myuser’@’localhost’ WITH GRANT OPTION;
FLUSH PRIVILEGES;