MySQL Bugs: #15036: won't run script that does more than one grant in a row

Bug #15036	won't run script that does more than one grant in a row
Submitted:	17 Nov 2005 22:09	Modified:	19 Sep 2006 8:31
Reporter:	Jeff Smith	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S2 (Serious)
Version:	1.1.17	OS:	Windows (Windows)
Assigned to:	Mike Lischke	CPU Architecture:	Any
Tags:	Source Editors

Description:
When I execute a script in Query Browser that does two grants in a row, it generates an error message. This same script executes without error from the mysql> command line.

I've included the script below:

How to repeat:
#### ADD ADMIN USERS #################

GRANT ALL PRIVILEGES ON mapp.* TO jssmith@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON mysql.user TO jssmith@'%' WITH GRANT OPTION;

#### ADD MAPP NON-ADMIN USERS ##########

GRANT INSERT,UPDATE,DELETE,SELECT ON mapp.* TO schaffer@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;

Thank you for a bug report. Verified just as described on XP. 

Looks like QB incorrectly passes any several statements delimited with ';' as a single SQL statement...

This issue also exists in the 1.1.15 version as well.

Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at

  http://www.mysql.com/downloads/