摘要：登錄查看當前數據存儲目錄關閉確認的確關閉關閉無誤，輸出類似轉移數據目錄備份源數據是為了保證中驗證目錄正確修改配置權限修改追加以下內容到重啟沒有追加內容，可能導致啟動原文鏈接歡迎您加入我們的專屬討論群組

mysql -uroot -p

mysql> select @@datadir;

+-----------------+
| @@datadir       |
+-----------------+
| /var/lib/mysql/ |
+-----------------+
1 row in set (0.00 sec)

sudo systemctl stop mysql

sudo systemctl status mysql

關閉無誤，輸出類似 "Jul 18 11:24:20 ubuntu-512mb-nyc1-01 systemd[1]: Stopped MySQL Community Server."

sudo rsync -av /var/lib/mysql /data/

sudo mv /var/lib/mysql /var/lib/mysql.bak
sudo mkdir /var/lib/mysql/mysql -p

sudo mkdir /var/lib/mysql/mysql -p 是為了保證 /usr/share/mysql/mysql-systemd-start 中驗證目錄正確

datadir=/data/mysql

alias /var/lib/mysql/ -> /data/mysql/,

sudo systemctl restart apparmor

沒有追加alias內容，可能導致

Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" 
and "journalctl -xe" for details.

sudo systemctl start mysql
sudo systemctl status mysql

原文鏈接
https://www.digitalocean.com/...

歡迎您加入我們的專屬QQ討論群組① 233415606 ② 233415756