I want to start scheduling remote mysqldump crons, and I'd prefer to use a special account for that purposes. I want to grant that user the minimum permissions for getting a full dump, but I'm not sure the best way to go about that.
Is it as simple as
grant SELECT on *.* to '$username'@'backuphost' identified by 'password';
or am I missing a better way?