Moving MariaDB/mysql to another drive

[Paul Groves]

The permissions on /home/mysql/ are set the same as they were before I moved it from /var/lib/mysql/ (see below).
The new symlink at /var/lib/mysql is owned by root:root and has 777 permissions.

so I don't think it is that? Does this look right?

paul at nas02:~$ ls -la /home/mysql/
total 188512
drwxr-xr-x  6 mysql mysql     4096 Jul 19 13:31 .
drwxr-xr-x 42 root  root      4096 Jul 19 13:29 ..
-rw-rw----  1 mysql mysql    16384 Jul 19 14:02 aria_log.00000001
-rw-rw----  1 mysql mysql       52 Jul 19 14:02 aria_log_control
-rw-r--r--  1 root  root         0 Jul 19 01:45 debian-10.3.flag
-rw-rw----  1 mysql mysql    11566 Jul 19 13:25 ib_buffer_pool
-rw-rw----  1 mysql mysql 79691776 Jul 19 14:06 ibdata1
-rw-rw----  1 mysql mysql 50331648 Jul 19 14:06 ib_logfile0
-rw-rw----  1 mysql mysql 50331648 Jul 19 14:06 ib_logfile1
-rw-rw----  1 mysql mysql 12582912 Jul 19 13:31 ibtmp1
drwx------  2 mysql mysql     4096 Jul 19 02:02 kodi_music72
drwx------  2 mysql mysql     4096 Jul 19 02:02 kodi_video116
-rw-rw----  1 mysql mysql        0 Jul 19 01:45 multi-master.info
drwx------  2 mysql mysql     4096 Jul 19 01:45 mysql
-rw-r--r--  1 root  root        15 Jul 19 01:45 mysql_upgrade_info
drwx------  2 mysql mysql     4096 Jul 19 01:45 performance_schema
-rw-rw----  1 mysql mysql    24576 Jul 19 13:31 tc.log


Regards
Paul

On 19/07/2022 13:26, Karl Auer wrote:
> On Tue, 2022-07-19 at 13:15 +0100, Paul Groves wrote:
>> Can't create test file /var/lib/mysql/nas02.lower-test
>> Jul 19 13:09:59 nas02 mysqld[24144]: #007/usr/sbin/mysqld: Can't
>> change dir to '/var/lib/mysql/' (Errcode: 13 "Permission denied")
> 
> Well, just a wild shot in the dark here, but could it be related to -
> permissions?!?
> 
> Regards, K.
>