mysql> grant select, show view, lock tables, reload, replication client, event, trigger on *.* to 'backup'@'%' identified by 'backup'; mysql> flush privileges;