- 创建数据文件夹
mkdir /data
- 查看数据存储路径
SHOW global variables LIKE "%datadir%";
- 停止MySQL
systemctl stop mysqld
- 修改配置文件
cp /etc/my.cnf /etc/my.cnf.bak
vim /etc/my.cnf
修改datadir和socket
#datadir=/var/lib/mysql
#socket=/var/lib/mysql/mysql.sock
datadir=/data/mysql
socket=/data/mysql/mysql.sock
- 迁移数据文件
mv /var/lib/mysql /data/
- 创建socket软连接
mkdir /var/lib/mysql
ln -s /data/mysql/mysql.sock /var/lib/mysql/mysql.sock
- 启动MySQL
systemctl start mysqld