在RHEL、CentOS、Fedora和其他类似的Linux发行版上,强烈建议使用yum或dnf从MariaDB的存储库安装相关的RPM包。
本篇文章安装10.4.14版本的MariaDB。
1.1 添加MariaDB yum存储库
1.1.1 使用MariaDB Package Repository安装脚本
[root@localhost ~]# curl -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | bash
[info] Repository file successfully written to /etc/yum.repos.d/mariadb.repo
[info] Adding trusted package signing keys...
[info] Successfully added trusted package signing keys
1.1.2 使用MariaDB Repository配置工具
vi /etc/yum.repos.d/mariadb.repo
注释掉以下内容:
[mariadb-main]
name = MariaDB Server
baseurl = https://downloads.mariadb.com/MariaDB/mariadb-10.5/yum/rhel/$releasever/$basearch
gpgkey = file:///etc/pki/rpm-gpg/MariaDB-Server-GPG-KEY
gpgcheck = 1
enabled = 1
添加以下内容:
[mariadb]
name = MariaDB-10.4.14
baseurl=http://yum.mariadb.org/10.4.14/centos7-amd64
# alternative: baseurl=http://archive.mariadb.org/mariadb-10.4.14/yum/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
#备注:这里是计划安装10.4.14版本的MariaDB,如果想安装其他版本,请修改相应值。
1.2 使用yum安装MariaDB
yum install MariaDB-server galera-4 MariaDB-client MariaDB-shared MariaDB-backup MariaDB-common -y
#检查确认
[root@localhost mysql]# rpm -qa | grep Maria
MariaDB-compat-10.4.14-1.el7.centos.x86_64
MariaDB-server-10.4.14-1.el7.centos.x86_64
MariaDB-common-10.4.14-1.el7.centos.x86_64
MariaDB-shared-10.4.14-1.el7.centos.x86_64
MariaDB-client-10.4.14-1.el7.centos.x86_64
MariaDB-backup-10.4.14-1.el7.centos.x86_64
1.3 修改配置文件
vi /etc/my.cnf.d/server.cnf
在[mysqld]下添加:
log_error=/var/lib/mysql/error.log
log_bin=master-bin
1.4 启动MariaDB
#启动
systemctl start mariadb
#查看数据库状态
#查看数据库进程
[root@localhost network-scripts]# ps -ef | grep mysqld | grep -v 'grep'
mysql 2271 1 0 14:30 ? 00:00:00 /usr/sbin/mysqld
1.5 设置数据库开机自启动
systemctl enable mariadb
1.6 修改root密码
刚安装完数据库后,root默认密码为空。
alter user 'root'@'localhost' identified by '修改后的密码';
1.7 开放防火墙端口
如果防火墙是开启状态的话,需要开启防火墙端口:
[root@localhost ~]# firewall-cmd --add-port=3306/tcp --permanent
success
[root@localhost ~]# firewall-cmd --reload
success
[root@localhost ~]# firewall-cmd --list-ports
3306/tcp
1.8 关闭SELINUX
#临时关闭selinux(服务器重启后失效)
setenforce 0
#永久关闭
修改/etc/selinux/config文件
将SELINUX的值改为disabled
--本篇文章主要参考了https://mariadb.com/kb/en/yum/及
https://mariadb.com/kb/en/getting-installing-and-upgrading-mariadb/