Moving MariaDB/mysql to another drive

[Colin Law]

On Tue, 19 Jul 2022 at 15:43, Paul Groves <paul.groves.787 at gmail.com> wrote:
>
> No, because when I try and cd to the symlinkb at /var/lib/mysql as my user paul the symlink points me to /home/mysql/ which is owned by mysql:mysql and my user paul does not have permissions to access it.

Please do not top post on this list, the forum is to place replies
below relevant parts of previous mail.

You can run commands as another user like this
sudo -H -u mysql bash -c 'echo "I am $USER, with uid $UID"'

Colin

>
> Paul
>
>
> On 19/07/2022 14:47, Colin Law wrote:
> > On Tue, 19 Jul 2022 at 14:39, Paul Groves <paul.groves.787 at gmail.com> wrote:
> >>
> >> 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.
> >
> > Can a non-root user cd to /var/lib/mysql and create files there?
> >
> > Colin
> >
>
> --
> ubuntu-users mailing list
> ubuntu-users at lists.ubuntu.com
> Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users