I am designing a backup schema for my server and want to use an isolated user who only has read privs to issue mysqldump. I'm planning on using --single-transaction as well.
I /presume/ that SELECT and LOCK TABLES are === the privs I need? Do I even need LOCK TABLES (I assumed I did for --single-transaction support)?
(I will implement InnoDB binary backups at some point, but for the time being...mysqldump's my only feasible option, in case someone was thinking of suggesting it
)