How to create user to taking backup only in mySQL ? MySQL


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, REPLICATION CLIENT ON *.* TO ‘userName’@’%’; Step: 3 FLUSH PRIVILEGES; 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.  

Read More