Not the answer you need?
Register and ask your own question!

Permission error after changing datadir

VRulerVRuler EntrantCurrent User Role Beginner
Hi, i'm having a permission error after changing the datadir to a different hard disk. Tried chown and chmod(even 777) but I'm still getting an error when trying to start the server.

Any suggestion is welcomed, thanks.

oct 15 13:16:53 mavacorp-System-Product-Name mysqld[43616]: mysqld: Can't change dir to '/media/mavacorp/nvme1/mysql/' (Errcode: 13 - Permission denied)
oct 15 13:16:53 mavacorp-System-Product-Name mysqld[43616]: 2018-10-15T10:16:53.779288Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
oct 15 13:16:53 mavacorp-System-Product-Name mysqld[43616]: 2018-10-15T10:16:53.779467Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
oct 15 13:16:53 mavacorp-System-Product-Name mysqld[43616]: 2018-10-15T10:16:53.918279Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql mode
oct 15 13:16:53 mavacorp-System-Product-Name mysqld[43616]: 2018-10-15T10:16:53.918296Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
oct 15 13:16:53 mavacorp-System-Product-Name mysqld[43616]: 2018-10-15T10:16:53.918335Z 0 [Warning] Can't create test file /media/mavacorp/nvme1/mysql/mavacorp-System-Product-
oct 15 13:16:53 mavacorp-System-Product-Name mysqld[43616]: 2018-10-15T10:16:53.918350Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.23-23) starting as process 43618 ...
oct 15 13:16:53 mavacorp-System-Product-Name mysqld[43616]: 2018-10-15T10:16:53.919822Z 0 [Warning] Can't create test file /media/mavacorp/nvme1/mysql/mavacorp-System-Product-
oct 15 13:16:53 mavacorp-System-Product-Name mysqld[43616]: 2018-10-15T10:16:53.919830Z 0 [Warning] Can't create test file /media/mavacorp/nvme1/mysql/mavacorp-System-Product-
oct 15 13:16:53 mavacorp-System-Product-Name mysqld[43616]: 2018-10-15T10:16:53.920116Z 0 [ERROR] failed to set datadir to /media/mavacorp/nvme1/mysql/
oct 15 13:16:53 mavacorp-System-Product-Name mysqld[43616]: 2018-10-15T10:16:53.920123Z 0 [ERROR] Aborting
oct 15 13:16:53 mavacorp-System-Product-Name mysqld[43616]: 2018-10-15T10:16:53.920140Z 0 [Note] Binlog end
oct 15 13:16:53 mavacorp-System-Product-Name mysqld[43616]: 2018-10-15T10:16:53.920173Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
oct 15 13:16:53 mavacorp-System-Product-Name mysqld[43616]: Initialization of mysqld failed: 0
oct 15 13:16:53 mavacorp-System-Product-Name systemd[1]: mysql.service: Control process exited, code=exited status=1
oct 15 13:16:53 mavacorp-System-Product-Name systemd[1]: mysql.service: Failed with result 'exit-code'.
oct 15 13:16:53 mavacorp-System-Product-Name systemd[1]: Failed to start Percona Server.

Comments

  • przemekprzemek Percona Support Engineer Percona Staff Role
    Hi,
    Check your SELinux or Apparmor context. For Selinux system, check the new datadir vs the old one with
    ls -lZ
    
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.