## MySQL 遷移數據文件存儲路徑
操作系統：centos
軟件：MySQL，PHP
### 停止MySQL服務
```
[root@centos]# systemctl stop mysqld.service
```
### 查看MySQL數據文件所屬用戶和組
MySQL數據文件默認是屬于mysql組和mysql用戶的
```
[root@centos]# ls -l /var/lib
total 120
……
drwxr-x--x 11 mysql mysql 4096 Dec 20 09:38 mysql_bak
……
```
### 遷移文件
把MySQL數據文件從`/var/lib/mysql`遷移到 `/data/server/mysql`
```
[root@centos]# mv /var/lib/mysql /data/server/
```
### 修改新目錄所屬用戶和組
把新目錄的所屬用戶和組修改為和之前一樣
```
[root@centos]# chown -R mysql:mysql /data/server/mysql
```
### 修改MySQL配置
修改`mysqld`，`client`，`mysql`節的配置，修改完畢后啟動`mysqld`服務
```
[mysqld]
#datadir=/var/lib/mysql
#socket=/var/lib/mysql/mysql.sock
##上面兩行改為下面兩行
datadir=/data/server/mysql
socket=/data/server/mysql/mysql.sock
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
#下面的行是新增的
[client]
default-character-set=utf8
socket=/data/server/mysql/mysql.sock
[mysql]
default-character-set=utf8
socket=/data/server/mysql/mysql.sock
```
### 啟動mysqld服務
```
[root@centos]# systemctl start mysqld.service
```
### 修改PHP配置文件
修改`php.ini`中`mysqli.default_socket`和`pdo_mysql.default_socket`，修改后要重啟php-fpm服務
```
mysqli.default_socket = /data/server/mysql/mysql.sock
pdo_mysql.default_socket = /data/server/mysql/mysql.sock
```
### 查看phpinfo
### 重啟php-fpm服務
```
[root@centos]# systemctl restart php-fpm.service
```
### 測試是否成功
```
[root@centos]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 14310
Server version: 8.0.18 MySQL Community Server - GPL
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
```
### 測試PHP是否成功連接MySQL
