Comment 4 for bug 1088967

Revision history for this message
Miguel Angel Nieto (miguelangelnieto) 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.