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

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

Thank you for the report.

Verified  as described on Linux using last BK sources.

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().

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.

Page generated in 0.062 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.