mysql 5.7存储目录迁移

停止服务器

mysqladmin -u root -p shutdown

拷贝到指定目录

cp -R /var/lib/mysql /home/data/

修改访问权限

chown -R mysql:mysql /home/data

修改/etc/my.cnf

[mysqld]
#datadir=/var/lib/mysql
datadir=/home/data
#socket=/var/lib/mysql/mysql.sock
socket=/home/data/mysql/mysql.sock

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

[mysql]
default-character-set=utf8
socket=/home/data/mysql/mysql.sock

修改/etc/selinux/config

SELINUX=disabled

设置

setenforce 0 

启动

systemctl start mysqld