centos7用yum安装mariadb最新版(10.3)

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

添加内容：

[mariadb]
name = MariaDB
baseurl = http://mirrors.ustc.edu.cn/mariadb/yum/10.3/centos7-amd64
gpgkey=https://mirrors.ustc.edu.cn/mariadb/yum/RPM-GPG-KEY-MariaDB
gpgcheck=0

安装依赖包： yum install -y yum-utils device-mapper-persistent-data lvm2

yum -y install  MariaDB-server MariaDB-client

systemctl restart mariadb
systemctl enable mariadb
mysql_secure_installation
mysql -uroot -p
systemctl stop mariadb

 

cp -r /var/lib/mysql /mnt/data1/data/appdata/maria_data/
chmod -R 777 /mnt/data1/data/appdata/

systemctl start mariadb
CREATE USER 'root'@'%' IDENTIFIED BY '123123!'; 
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'lijun123' WITH GRANT OPTION;  flush privileges;

# vim /etc/my.cnf.d/server.cnf
在[mysqld]下面添加：
datadir=/mnt/data1/data/appdata/maria_data/mysql
log-error=/mnt/data1/data/logs/mariadb/mysql.log
slow-query-log-file =/mnt/data1/data/logs/mariadb/mysql-slow.log
skip-external-locking
log-bin=mysql-bin
binlog_format=mixed
innodb_lock_wait_timeout=10
event_scheduler=1

quick
max_allowed_packet = 16M