ubuntu-16.04更改mysql默认数据存储目录

摘要：登录查看当前数据存储目录关闭确认的确关闭关闭无误，输出类似转移数据目录备份源数据是为了保证中验证目录正确修改配置权限修改追加以下内容到重启没有追加内容，可能导致启动原文链接欢迎您加入我们的专属讨论群组

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