環(huán)境安裝參考： 306-Ubuntu16.04 安裝LNAMP
Ubuntu16.04 修改mysql5.7.23 的root密碼

1. 創(chuàng)建數(shù)據(jù)目錄

> mkdir /51nst/data/mysql

復(fù)制mysql默認(rèn)目錄數(shù)據(jù),并設(shè)置權(quán)限

> cp -arx /var/lib/mysql/* /51nst/data/mysql/
> chown -R mysql:mysql /51nst/data/mysql

2. 修改vim /etc/apparmor.d/usr.sbin.mysqld

> vim /etc/apparmor.d/usr.sbin.mysqld

# 找到對(duì)應(yīng)部分，進(jìn)行修改
# Allow data dir access
#  /var/lib/mysql/ r,
#  /var/lib/mysql/** rwk,
  /51nst/data/mysql/ r,
  /51nst/data/mysql/** rwk,

3. 配置mysql

> vim /etc/mysql/mysql.conf.d/mysqld.cnf

# 將對(duì)應(yīng)部分進(jìn)行修改
#datadir                = /var/lib/mysql 修改為如下
datadir         = /51nst/data/mysql

4. 重啟

> service apparmor restart
> service mysql restart

查看配置

> mysql -u root -p

mysql> show variables like '%datadir%';
+---------------+--------------------+
| Variable_name | Value              |
+---------------+--------------------+
| datadir       | /51nst/data/mysql/ |
+---------------+--------------------+
1 row in set (0.00 sec)