grant on master could break replication and unauthorised user creation slaves

[Miguel Angel Nieto]

Latest Percona Server 5.1.73.

Master with slave.

On master as root:

grant usage,select,create routine,execute on test.* to 'miguel'@'%' with grant option;

On master as miguel:

CREATE FUNCTION hello (s CHAR(20)) RETURNS CHAR(50) DETERMINISTIC RETURN CONCAT('Hello, ',s,'!');

GRANT EXECUTE on FUNCTION hello TO 'yyy'@'%';

Last command fails with:

ERROR 1410 (42000): You are not allowed to create a user with GRANT

and slave breaks with:

               Last_SQL_Error: Query caused different errors on master and slave. Error on master: message (format)='You are not allowed to create a user with GRANT' error code=1410 ; Error on slave: actual message='no error', error code=0. Default database: 'test'. Query: 'GRANT EXECUTE on FUNCTION hello TO 'yyy'@'%''

so, the user yyy is created on the slave.

[Miguel Angel Nieto (miguelangelnieto)]

Tested in PS 5.1 and PS 5.5. It doesn't fail on PS 5.6 and the user is also not created.

Tested in MySQL 5.1 and MySQL 5.5. It doesn't fail on MySQL 5.6 and the user is also not created.

[Shahriyar Rzayev (rzayev-sehriyar)]

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