Bug #5674 'mysqladmin proc' returns error
Submitted: 20 Sep 2004 20:14 Modified: 7 Oct 2004 22:40
Reporter: [ name withheld ] Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S1 (Critical)
Version:4.0.20a-nt OS:Windows (win 2K SBS)
Assigned to: Matthew Lord CPU Architecture:Any

[20 Sep 2004 20:14] [ name withheld ] 
Description:
On new installation with the 4 default accounts, 'mysqladmin proc' returns: 

mysqladmin: process list failed; error: 'Access denied. You need the PROCESS provilege for this operation'

How to repeat:
type:
mysqladmin proc

Suggested fix:
default accounts (at least 2 of them) should have PROCESS privilege according to the documentation.
[7 Oct 2004 22:40] Matthew Lord 
Hi,

Thank you for your bug report!

There are 4 accounts created by default, root@localhost, root@%, ''@localhost and ''@%.  The '' 
accounts are anonymous accounts which do not have the PROCESS privilege.  When you don't 
specify a user then you will be logged in as the anonymous account if it exists.  This is why you 
are getting the access denied error.  mysqladmin -u root proc should work.

Best Regards