vim /etc/yum.repos.d/mariadb.repo

[mariadb]
name=MariaDB
baseurl=https://mirrors.aliyun.com/mariadb/yum/10.11/centos7-amd64/
gpgkey=https://mirrors.aliyun.com/mariadb/yum/RPM-GPG-KEY-MariaDB
gpgcheck=1
enabled=1

安装

yum install -y mariadb-server

检查

mariadb --version

rpm -qa |grep -i mariadb

加入开机自启

systemctl enable mariadb

启动服务

systemctl start mariadb

mariadb-secure-installation


1、进入数据库
[root@abc /]# mysql -uroot -p
Enter password: 

2、设置远程登录账号
MariaDB [(none)]> grant all on *.* to 'test'@'%' identified by '123456' with grant option;
Query OK, 0 rows affected (0.084 sec)

3、刷新配置
flush privileges;