如果ntfs文件样式上存在数据目录，则无法启动mysql。

Question

sudo mysqld --debug
2016-06-06 11:02:35 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
2016-06-06 11:02:35 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-06-06 11:02:35 0 [Note] mysqld (mysqld 5.6.30-0ubuntu0.14.04.1) starting as process 25351 ...
2016-06-06 11:02:35 25351 [Warning] Can't create test file /mnt/01D0900CA5E8F760/ProgramData/MySQL/MySQLServer5.6/ashish-ratan.lower-test
2016-06-06 11:02:35 25351 [Warning] Can't create test file /mnt/01D0900CA5E8F760/ProgramData/MySQL/MySQLServer5.6/ashish-ratan.lower-test

mysqld配置：

[mysqld]
#
# * Basic Settings
#
user        = mysql
pid-file    = /var/run/mysqld/mysqld.pid
socket      = /var/run/mysqld/mysqld.sock
port        = 3306
basedir     = /usr
#datadir        = /var/lib/mysql
datadir     =/mnt/01D0900CA5E8F760/ProgramData/MySQL/MySQLServer5.6
tmpdir      = /tmp

我在这个案子里到底有什么

在linux中使用Windows数据目录，因为我已经在NTFS上上传了我的大数据库，现在我想在linux中使用这个目录。

Answer 1

更改数据目录后，需要更改Apparmor设置以解决权限问题。

1. 开放/etc/apparmor.d/usr.sbin.mysqld
2. 注释掉/var/lib/mysql/ r, /var/lib/mysql/** rwk,
3. 然后是/mnt/01D0900CA5E8F760/ProgramData/MySQL/MySQLServer5.6/ r, /mnt/01D0900CA5E8F760/ProgramData/MySQL/MySQLServer5.6/** rwk,
4. 还要确保正确地将权限分配给数据目录。
5. 再次尝试重新启动MySQL服务。