1. 停止數(shù)據(jù)庫(kù)服務(wù)
systemctl stop mysqld
2. 遷移目錄
cd /var/lib/mysql
cp -rf ./* /home/mysql/data
cd /home
chown -R mysql:mysql mysql
3. 修改配置文件my.cnf
datadir=/home/mysql/data
socket=/home/mysql/data/mysql.sock
4. 啟動(dòng)mysql
systemctl start mysqld
查看：
mysql> show VARIABLES like 'datadir';
+---------------+-------------------+
| Variable_name | Value |
+---------------+-------------------+
| datadir | /home/mysql/data/ |
+---------------+-------------------+
1 row in set (0.00 sec)
5. 如果報(bào)錯(cuò)：
mysqld: File ‘./binlog.index‘ not found (OS errno 13 - Permission denied)
關(guān)掉selinux
臨時(shí)返敬，重啟服務(wù)器失效
[root@localhost ~]# setenforce 0
永久, xu'y
vi /etc/selinux/config
修改： SELINUX=disabled
再次啟動(dòng)成功
6. 連接報(bào)錯(cuò)
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
修改配置文件
增加
[mysql]
socket=/data/mysql/mysql.sock
