Thanks for the review. Some comments...
> 1. In tests use a user who has all rights except possibly BACKUP/RESTORE
> so that if BACKUP/RESTORE operation is refused it is because of missing
> BACKUP/RESTORE privileges and not for other reasons.
> CREATE USER test_user;
> GRANT ALL ON *.* TO test_user;
> REVOKE BACKUP,RESTORE ON *.* FROM test_user;
> Then these scenarios can be tested:
> - GRANT BACKUP/RESTORE ON *.* TO test_user;
> - GRANT BACKUP/RESTORE ON specific_db.* TO test_user;
> 2. Test additional scenarios where an explicit list of databases (more
> than 1) is given to BACKUP command and where RESTORE restores more than
> one database. User has privileges for some of the databases but not for
I will wait on this one. I think if I add it now, BUG#44787 will force a
change. Thus, I will leave this one to BUG#44787. I have added your statements
to that bug.