MySQL Bugs: #22958: Com_create_user missing within 5.0

Bug #22958	Com_create_user missing within 5.0
Submitted:	3 Oct 2006 18:54	Modified:	11 Dec 2006 3:47
Reporter:	Mark Leith	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: General	Severity:	S3 (Non-critical)
Version:	5.0	OS:	Any (All)
Assigned to:	Magnus Blåudd	CPU Architecture:	Any
Tags:	com_create_user, create user, STATUS

Description:
Now that we have CREATE USER within 5.0, we should also have the corresponding "Com_create_user" status variable as well. Currently we have Com_drop_user, without Com_create_user. 

Furthermore, when somebody issues a CREATE USER statement it is impossible to track this via the status variables, as not even Com_grant is increased. 

How to repeat:
SHOW GLOBAL STATUS LIKE 'Com_create_user';

Suggested fix:
Add a new Com_create_user status variable that is incremented for every CREATE USER statement.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/14563

ChangeSet@1.2333, 2006-10-30 15:59:47+01:00, msvensson@shellback.(none) +1 -0
  Bug#22958 Com_create_user missing within 5.0
   - Add Com_create_user to SHOW STATUS command

Noted in 5.0.32, 5.1.15 changelogs.

The Com_create_user status variable was added (for counting CREATE
USER statements).