centos安装mariadb

1.清空老版本

rpm -qa | grep mysql

2.编辑源

vi /etc/yum.repos.d/Mariadb.repo

# MariaDB 10.1 CentOS repository list - created 2016-12-01 03:36 UTC
# http://downloads.mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.1/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

3.安装

yum -y install MariaDB-server MariaDB-client

4.开机启动

systemctl daemon-reload
systemctl enable mariadb
systemctl start mariadb
systemctl status mariadb

5.修改存储路径

cp -r /var/lib/mysql /home/deshine/data/
chown mysql:mysql -R /home/deshine/data/mysql/
vi /etc/my.cnf

#
# This group is read both both by the client and the server
# use it for options that affect everything
#

[client]
port = 3306
socket = /home/deshine/data/mysql/mysql.sock
default-character-set=utf8

[mysql]
default-character-set=utf8

[mysqld]
init_connect='SET collation_connection = utf8_unicode_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_unicode_ci
skip-character-set-client-handshake
port=3306
user=mysql
datadir=/home/deshine/data/mysql
socket=/home/deshine/data/mysql/mysql.sock
thread_concurrency=8
max_connections=2000
skip-name-resolve
character_set_server = utf8
server-id = 2
log-bin=mysql-bin
relay-log=relay-bin
log-slave-updates=1
read-only=1
lower_case_table_names = 1

[mysqld_safe]
socket=/var/lib/mysql/mysql.sock

[mysql.server]
socket=/var/lib/mysql/mysql.sock

[client-server]

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

修改mysql.service，否则无法将目录转移到home目录，被这个坑了好久
vi /etc/systemd/system/mysql.service

ProtectHome=false