On 2/27/04, 10:12:56 AM, Jim Shea <[EMAIL PROTECTED]> wrote regarding Minimum privileges required for mysqldump:
> I want to create a user that has the minimum rights to dump a database. I > can't find a discussion of the minimum required rights in the MySQL docs.
At 2/27/2004 08:35 AM, [EMAIL PROTECTED] wrote:
The user will need SELECT access to the table(s) in question.
grant select on dbname.* to [EMAIL PROTECTED];
will allow a
mysqldump -ubackupuser -ppassword dbname > dbname.dump.sql
but coughs on the mysqldump option "--opt"
mysqldump -ubackupuser -ppassword --opt dbname > dbname.dump.sql
mysqldump: Got error: 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'dbname' when using LOCK TABLES
Giving the "lock tables" permission as in: grant select, lock tables on dbname.* to [EMAIL PROTECTED];
results in the same mysqldump error.
If it matters my server version: 4.0.18-max-nt
Thanks
Jim
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
