Although phpMyAdmin provides a nice GUI, it is not required to alter the database. The
mysql command line tool can be used from any shell/terminal/emulator/SSH, according to the HowTo:
mysql -u<rootuser> -p
# enter mysql root password, then within mysql console:
update oc_storages set id='local::/new/path/to/data/' where id='local::/path/to/data/'; //take care about backslash at the end of path!!
<rootuser> is “
root”, with MariaDB on modern Debian at least the
-p option must or can be omitted when you logged in as root UNIX user. You could also use the Nextcloud database user, where
/path/to/nextcloud/config/config.php provides its name and password.
Actually using Nextcloud database user is the much better way, since it has only permissions to alter the Nextcloud database and no other, hence one cannot by accident break something within other databases. Something I’ll edit in the HowTo another day .