Archive for the ‘mysql’ Tag

Creating a backup user for doing a mysqldump   Leave a comment

Creating a user just for doing the backups via mysqldump is really simple.  In mysql just issue the following grant statement,

grant select, lock tables on mydatabase.* to 'backup'@'localhost' identified by 'password';

Posted October 3, 2008 by colinnewell in Configuration, Programming

Tagged with ,

Follow

Get every new post delivered to your Inbox.

Join 38 other followers