yum install mariadb mariadb-server
systemctl enable mariadb
mysql_secure_installation

vim /etc/my.cnf

bind-address = 0.0.0.0

firewall-cmd –zone=public –add-service=mysql –permanent firewall-cmd –reload </code>

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;

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