Bug #22723 Host field blank when server started with skip-grant
Submitted: 27 Sep 2006 4:52 Modified: 13 Nov 2006 19:45
Reporter: Jeremy Cole Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.25, 5.1 BK OS:Linux (Linux)
Assigned to: Ramil Kalimullin CPU Architecture:Any

[27 Sep 2006 4:52] Jeremy Cole
Description:
When the server is started with skip-grant, the Host field in SHOW PROCESSLIST always shows blank.

How to repeat:
1. Start the server with skip-grant
2. Connect
3. SHOW PROCESSLIST
[27 Sep 2006 10:56] Sveta Smirnova
Thank you for the report.

Verified  as described on Linux using last BK sources.
[20 Oct 2006 10:08] Bugs System
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/14035

ChangeSet@1.2297, 2006-10-20 15:08:25+05:00, ramil@mysql.com +1 -0
  Fix for bug #22723: Host field blank when server started with skip-grant
  
  We set 'host_or_ip' to "" in the Security_context::skip_grants().
[13 Nov 2006 19:45] Paul DuBois
Noted in 5.0.30 (not 5.0.29), 5.1.13 changelogs.

The Host column in SHOW PROCESSLIST output was blank when the server
was started with the --skip-grant-tables option.