Hi. I am useing MiriaDB and OC 188.8.131.52. We are redoing our backup stratergy and wish to backup the database using another servfer on the same local network. I have set bind-address in /etc/mysql/mariadb.conf.d/mysql.cnf but also need to grant access to the owncloud database to the remote server. Have done some googeling and know I need to run a grant comand and possibly setup a user. It would be good for someone to advise on what grant etc. comand is best and the comand line on the remote server. I think the later is somethingf like
$ mysql -h192.168.1.50 -uowncloud -ppassword owncloud > backup.sql.
to aid comunicasion lets call the owncloud database 'owncloude' , the ownCloud server 192.168.1.100 and the backup server 192.168.1.110.