1. 停止數(shù)據(jù)庫服務(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. 啟動mysql

systemctl start mysqld

查看：

mysql> show VARIABLES like 'datadir';
+---------------+-------------------+
| Variable_name | Value             |
+---------------+-------------------+
| datadir       | /home/mysql/data/ |
+---------------+-------------------+
1 row in set (0.00 sec)

5. 如果報錯：

mysqld: File ‘./binlog.index‘ not found (OS errno 13 - Permission denied)

關(guān)掉selinux

臨時，重啟服務(wù)器失效
[root@localhost ~]# setenforce 0

永久, xu'y
vi /etc/selinux/config
修改： SELINUX=disabled

再次啟動成功

6. 連接報錯

 Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

修改配置文件

增加
[mysql]  
socket=/data/mysql/mysql.sock 

重啟