curl -LsS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash

dnf repolist

sudo dnf install MariaDB-server

systemctl start mariadb

systemctl enable mariadb

systemctl status mariadb

sudo firewall-cmd --permanent --add-service=mysql

firewall-cmd --reload

sudo mariadb-secure-installation

mariadb -h localhost -p3306 -u root -p

Create user for remote connection

CREATE USER nonroot@'%' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES ON *.* TO 'nonroot'@'%' WITH GRANT OPTION;

FLUSH PRIVILEGES;

Configure MariaDB server for allowing remote connection

vim /etc/my.cnf.d/server.cnf

mariadb -h 192.168.1.101 -p3306 -u nonroot -p

備注：

1. 查詢Maria DB版本，可使用命令select version();或status或rpm -qa | grep mariadb