MariaDB

Installation

yum install mariadb mariadb-server
systemctl enable mariadb
mysql_secure_installation

Première base

CREATE DATABASE dbplop CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci;
CREATE USER 'uplop'@'localhost' IDENTIFIED BY 'pwdplop';
GRANT ALL ON dbplop.* TO 'uplop'@'localhost' IDENTIFIED BY 'pwdplop';
FLUSH PRIVILEGES;

Read Only

GRANT SELECT ON 'dbplop' TO 'rouplop'@'192.168.0.%' IDENTIFIED BY ropwdplop';
FLUSH PRIVILEGES;