[DOC] SQL to create backup user syntax error on v5.1

[David I]

[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'

[David I (david-ishee)]

Reference: http://www.percona.com/doc/percona-xtrabackup/innobackupex/privileges.html

[David I (david-ishee)]

I was logged in as the 'root' user at the time.

[David I (david-ishee)]

I skipped the REVOKE command and moved on with the GRANT statement and it worked.

[Miguel Angel Nieto (miguelangelnieto)]

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.

[David I (david-ishee)]

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

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXB-610