centos7 mysql5.7修改数据目录
原目录:/var/lib/mysql
迁移后目录:/data/mysqldata
-
停止mysql服务
systemctl stop mysqld
- 创建mysql数据目录
mkdir /data/mysqldata
- 拷贝mysql数据目录到新目录,注意:-a参数
cp -a /var/lib/mysql /data/mysqldata
- 修改my.cnf配置文件
vi /etc/my.cnf
datadir=/data/mysqldata/mysql
socket=/data/mysqldata/mysql/mysql.sock
此时重启mysql会报如下错:
InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
- 修改/etc/selinux/config文件,关闭SELINUX
将SELINUX=enforcing修改成SELINUX=disabled
- 重启系统
reboot
- 启动mysql服务
systemctl start mysqld