在CentOS 8.4上安装MariaDB 10.6

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

作者：vivaleo
链接：https://www.jianshu.com/p/afdc8a213158
来源：简书
著作权归作者所有。商业转载请联系作者获得授权，非商业转载请注明出处。