Bug #38533 Can't assign previledges to ANYHOST easily
Submitted: 3 Aug 2008 23:50 Modified: 3 Feb 2009 21:17
Reporter: Jared S (Silver Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Administrator Severity:S1 (Critical)
Version:1.2.12 OS:Windows (Any)
Assigned to: CPU Architecture:Any
Tags: anyhost, qc, users

[3 Aug 2008 23:50] Jared S 
Description:
Hi,

I strugle to assign remote priveledges to the core ROOT user as fresh install, I guess experts create various user as they need.  However assinning remote user priveledges for ROOT user should be just as easy.

CURRENT PROBLEM.  One has to add ANYHOST account to 'ROOT' user and receive an audible error before the priveledges tabe is 'ENABLED'

Dont know why is - plz fix!

How to repeat:
1. Find clean server if avaible
2. Create new DB from QB
3. Now use Admin progrm to allow the 'ROOT' @ % to have full priveledgesof that DB

RESULT is that the priveledges tab is grayed out until '%' is attemtped to be re-added with error.

Suggested fix:
Priveledge tab should always be enable when ROOT user is selected.
[7 Aug 2008 14:03] Sveta Smirnova 
Thank you for the report.

Verified as described.
[3 Feb 2009 21:16] Jared S 
Non repo in 1.2.16 release.
[3 Feb 2009 21:17] Jared S 
Non repo in 1.2.16 release.