CentOS7安裝MariaDb

安裝Mariadb服務

yum install -y mariadb mariadb-server
           

安裝遇到版本沖突錯誤

file /etc/my.cnf conflicts between attempted installs of mysql-community-server-5.7.28-1.el7.x86_64 and MariaDB-common-10.4.8-1.el7.centos.x86_64

處理方法如下：

移除沖突版本，再進行安裝

yum -y remove mysql-community-common-5.7.27-1.el7.x86_64
yum install -y mariadb mariadb-server
           

啟動服務

systemctl start mariadb
           

初始化資料庫

mysql_secure_installation
           

設定root密碼

Enter current password for root (enter for none):

select host,user,password from user;