0

OS Ubuntu 18.04, laptop, ssd partitioned for two OS (win8 and linux), second drive mounted with permissions. Line from fstab:

UUID={UUID} /media/iam/storage ntfs-3g permissions 0 1

I created dir db/ in root dir of second drive, than do following step by step exactly as desribed. (Try, I mean. All breaks on step 9):

Moving the MySQL data directory Ubuntu 16.04

Got this error

-- Unit mysql.service has begun starting up.
янв 04 14:39:10 thevoid audit[5063]: AVC apparmor="STATUS" operation="profile_replace" info="same as current profile, skipping" profile="unconfined" name="/usr/sbin/mysqld" pid=5063 comm="a
янв 04 14:39:10 thevoid kernel: audit: type=1400 audit(1546601950.205:134): apparmor="STATUS" operation="profile_replace" info="same as current profile, skipping" profile="unconfined" name=
янв 04 14:39:10 thevoid mysqld[5064]: mysqld: Can't change dir to '/media/iam/storage/db/mysql/' (OS errno 13 - Permission denied)
янв 04 14:39:10 thevoid mysqld[5064]: 2019-01-04T11:39:10.441016Z 0 [Warning] [MY-010091] [Server] Can't create test file /media/iam/storage/db/mysql/thevoid.lower-test
янв 04 14:39:10 thevoid mysqld[5064]: 2019-01-04T11:39:10.441064Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.13) starting as process 5064
янв 04 14:39:10 thevoid mysqld[5064]: 2019-01-04T11:39:10.442897Z 0 [Warning] [MY-010091] [Server] Can't create test file /media/iam/storage/db/mysql/thevoid.lower-test
янв 04 14:39:10 thevoid mysqld[5064]: 2019-01-04T11:39:10.442905Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /media/iam/storage/db/mysql/ is c
янв 04 14:39:10 thevoid mysqld[5064]: 2019-01-04T11:39:10.442937Z 0 [ERROR] [MY-010172] [Server] failed to set datadir to /media/iam/storage/db/mysql/
янв 04 14:39:10 thevoid mysqld[5064]: 2019-01-04T11:39:10.442975Z 0 [ERROR] [MY-010119] [Server] Aborting
янв 04 14:39:10 thevoid mysqld[5064]: 2019-01-04T11:39:10.443075Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.13)  MySQL Community Server - GPL.
янв 04 14:39:10 thevoid systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
янв 04 14:39:10 thevoid systemd[1]: mysql.service: Failed with result 'exit-code'.
янв 04 14:39:10 thevoid systemd[1]: Failed to start MySQL Community Server.

I check permissions for folder mysql, they was 777 with root:root as owner. I change owner:

sudo chown -R mysql:mysql /media/iam/storage/db/mysql

iam@thevoid:/media/iam/storage/db$ ls -la
total 12
drwxrwxrwx 1 mysql mysql    0 янв  4 13:43 .
drwxrwxrwx 1 root  root  8192 янв  4 11:30 ..
drwxrwxrwx 1 mysql mysql 4096 янв  4 13:56 mysql

Then

sudo systemctl start mysql

and again got this error. What can I do with this? Why this can happen?

  • Smells like an apparmor setting issue. – Rick James Jan 4 at 21:33
  • @RickJames tried to purge apparmor, error the same, permision denied – iamthevoid Jan 5 at 9:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.