一、首先确保你要更改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服务