1.关闭mysql服务
systemctl stop mysqld
2.创建新的路径
mkdir -p /new/path
3.将现有数据移动新位置
cp -R /var/lib/mysql/* /new/datadir/path/
4.配置my.cnf
[mysqld]
datadir=/new/path
log-error=/new/path/log/mysqld.log
5.授权
chown -R mysql:mysql /new/path
chown -R mysql:mysql /new/path/log
chmod -R 777 /new/path
6.重启
systemctl start mysqld