Comment 5 for bug 1088967

That may be true in your documentation too, but I used a different username
as shown below so they matched in my case.

On Thursday, January 3, 2013, Miguel Angel Nieto <email address hidden>
wrote:

> It should be:
>
> mysql> CREATE USER 'bkpuser'@'localhost' IDENTIFIED BY 's3cret';
> mysql> REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'bkpuser'@'localhost';
> mysql> GRANT RELOAD, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'bkpuser'@
> 'localhost';
> mysql> FLUSH PRIVILEGES;
>
> The problem in the documentation is that first we create the user
> 'bkpuser'@'localhost' and then try to revoke privileges from 'bkuser'.
> Those are different users.
>
> ** Changed in: percona-xtrabackup
> Status: New => Confirmed
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/1088967
>
> Title:
> [DOC] SQL to create backup user syntax error on v5.1
>
> Status in Percona XtraBackup:
> Confirmed
>
> Bug description:
> [In:Percona XtraBackup Documentation]
>
> I tried executing the following SQL on MySQL v5.1 and got an error:
>
> CREATE USER 'backup'@'localhost' IDENTIFIED BY 'secret!';
> REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'backup';
>
>
> Error: General error message from server: "Can't revoke all privileges
> for one or more of the requested users"
> SQLState: S1000
> ErrorCode: 1269
> Error occured in:
> REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'backup'
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/percona-xtrabackup/+bug/1088967/+subscriptions
>

--
David