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