Hi @Jimbo
You have changed you root password and backup can’t work.
I suggest you to reset your root password and create an admin account to manage your database (e.g. with phpmyadmin).
Follow this procedure:
grep password .my.cnf
Copy this password and then launch this commands:
service mysqld stop
mysqld_safe --skip-grant-tables &
mysql
FLUSH PRIVILEGES;
set password for 'root'@'localhost' = PASSWORD('yourcopiedpwd');
And then:
service mysqld stop
service mysqld start
If from service interface mysql remains stopped launch this other commands:
mysqladmin shutdown
systemctl start mysqld
Then I suggest you to create an admin account with all privileges with this mysql command:
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' IDENTIFIED BY 'adminpassword';
You can use it for application like phpmyadmin.
Then you can check if backup works properly with command
backup-data -b backup-data
Wait for your feedback.
Regards.