DebuggerX
deepin
2018-02-13 22:16 MySQL data folder in Windows partition mounted under Ubuntu is not accepted by MySQL
--you're asking for trouble...
--you're asking for trouble...
Reply Like 0 View the author
https://bbs.deepin.org/post/153245
MySQL data folder in Windows partition mounted under Ubuntu is not accepted by MySQL
--you're askin ...
Popular Events
More
------------------------ 文件夹权限 --------------------------
➜ ~ ls -l /media/doggy/D
总用量 20
drwx------ 2 root root 16384 2月 13 11:43 lost+found
drwxrwxrwx 3 mysql mysql 4096 2月 13 13:11 mysql
------------------------------------------------------------------
----------------------- 错误日志 -------------------------------
2月 13 13:53:12 doggy-home mysqld[6401]: mysqld: Can't change dir to '/media/doggy/D/mysql/' (Errcode: 13 - Permission denied)
2月 13 13:53:12 doggy-home mysqld[6401]: 2018-02-13T05:53:12.364511Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2月 13 13:53:12 doggy-home mysqld[6401]: 2018-02-13T05:53:12.364568Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2月 13 13:53:12 doggy-home mysqld[6401]: 2018-02-13T05:53:12.508077Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2月 13 13:53:12 doggy-home mysqld[6401]: 2018-02-13T05:53:12.508121Z 0 [Warning] Can't create test file /media/doggy/D/mysql/doggy-home.lower-test
2月 13 13:53:12 doggy-home mysqld[6401]: 2018-02-13T05:53:12.508142Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.18-1) starting as process 6401 ...
2月 13 13:53:12 doggy-home mysqld[6401]: 2018-02-13T05:53:12.509719Z 0 [Warning] Can't create test file /media/doggy/D/mysql/doggy-home.lower-test
2月 13 13:53:12 doggy-home mysqld[6401]: 2018-02-13T05:53:12.509729Z 0 [Warning] Can't create test file /media/doggy/D/mysql/doggy-home.lower-test
2月 13 13:53:12 doggy-home mysqld[6401]: 2018-02-13T05:53:12.509757Z 0 [ERROR] failed to set datadir to /media/doggy/D/mysql/
2月 13 13:53:12 doggy-home mysqld[6401]: 2018-02-13T05:53:12.509762Z 0 [ERROR] Aborting
2月 13 13:53:12 doggy-home mysqld[6401]: 2018-02-13T05:53:12.509770Z 0 [Note] Binlog end
2月 13 13:53:12 doggy-home mysqld[6401]: 2018-02-13T05:53:12.509805Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
2月 13 13:53:12 doggy-home systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
-------------------------------------------------------------------