Is there simple command available to give limited access the user to take backup the database in mySQL WorkBench with limited access.
Step : 1
CREATE USER ‘username’@’%’ IDENTIFIED BY ‘pa$$w0rd’;
Step : 2
GRANT SELECT, SHOW VIEW, LOCK TABLES, RELOAD,
ON *.* TO ‘userName’@’%’;
The users not required INSERT or ALTER TABLE privileges to take backup te database. The above set of privileges enough to take the backup from the mysqldump programs. And it will be sufficient to backup database also.