I’m wondering what is the consensus for using the root - mysql user, for dumping the Nextcloud database, I’ve read some posts of users stating it is a bad idea to use root?
If you don’t need the permissions, it is better to use a user with limited access. So you wouldn’t run Nextcloud with root permissions. However, for the backup, as root, you can backup the all databases, not just the Nextcloud-db.
I have been using the mysql root user just for backing up/dumping the NC database, however that database has it’s own mysql user which Nextcloud uses for its operation.
I currently run an rsync backup on the entire server to backup/snapshot the entire system, as well as an additional backup following the Nextcloud admin manual recommendations (data folder, NC folder & NC SQL database).
As I have to run the backup’s manually (I use an encrypted external drive to store backups) I have to manually enter the mysql root password everytime. After reading a few posts I thought I may be in error using the root sql user.
Thanks for the clarification, it is much appreciated
depending on your distro mysql/mariadb may be preconfigured for root (locally) w/out password at all (eg debian.) if you execute the command mysql as root you are not required to supply the password and there is no .my.cnf with password either in this case.
you can also run mysqldump -u <USER> -p <PASS> .... inside your script if you consider this safe enough.
i usually run mysqldump as root since (a long time ago) i ran into some privilege problems with the db-users and also i backup all dbs at the same time.
GOOD LUCK!
I have noticed that I can log into MariaDB/mysql from root without the password (Ubuntu 20.04LTS).
I’ve been waiting until I feel more comfortable with Linux before I configure automated backups (I plan to use crontab).
You input has given me confidence that I am heading in the right direction, I really appreciate the input
