Thanks for Albertramsbottom offering a feedback to us.
The issue description
I just get the following error
Error: Backup error: SQLSTATE: Syntax error or access violation: 1044 Access denied for user ‘myuser’@’localhost’ to database ‘mydb’, task id: wpvivid-5c879c9530f36
The cause of issue
The MySQL user didn’t have sufficient privileges to database, which caused database backup failure.
Before creating backups for WordPress site, please make sure that the MySQL user is granted the all privileges to database. There are two different ways to grant privileges to users:
Method 1: log in phpmyadmin>>Users tab>>Edit Privileges of MySQL user>>Database-specific privileges>>Select your database>> Check All >> Click Go button.
Method 2: run the command line below:
msyql –u root –p; GRANT ALL PRIVILEGES ON database_name.* TO ‘user_name’@’localhost’; flush privileges;
Note: replace database_name and user_name with your database name and username.