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.
It should be:
mysql> CREATE USER 'bkpuser' @'localhost' IDENTIFIED BY 's3cret'; @'localhost' ; @'localhost' ;
mysql> REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'bkpuser'
mysql> GRANT RELOAD, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'bkpuser'
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.