centos 7.1系统更改Mariadb数据存储位置步骤分享

一、首先确保你要更改Mariadb数据存储的位置的空间够大

现在已将Mariadb存储位置更改到/opt/目录下

1.然后将Mariadb服务stop：systemctl stop mariadb

2.先创建你要更改存储的位置的路径，并赋权限给它
mkdir -p /opt/data/mysql_data/
chmod 777 /opt/data/mysql_data/
chmod 777 /opt/data/

3.再将mysql的数据文档路径下为/var/lib/mysql整个目录复制到/opt/data/mysql_data/
cp -r /var/lib/mysql/* /opt/data/mysql_data/

4.编辑mariadb的配置文档/etc/my.cnf

[mysqld]
#datadir=/var/lib/mysql
#socket=/var/lib/mysql/mysql.sock
datadir=/opt/data/mysql_data                       #数据存储位置 
socket=/opt/data/mysql_data/mysql.sock                    #mysql.sock产生的路径
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd
lower_case_table_names=1                                    #大小写敏感，0区分，1不区分

[client]
default-character-set=utf8
socket=/opt/data/mysql_data/mysql.sock            #mysql.sock产生的路径

[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log                #Mariadb的日志路径
pid-file=/var/run/mariadb/mariadb.pid                   #pid的路径

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

5.将/opt/data/mysql_data目录包含所有的子目录和文件，所有者改变为root,所属组改变为mysql
chown -R mysql:mysql /opt/data/mysql_data

6.启动Mariadb服务