Bug #6576 SELECT CURRENT_USER() returns incorrect host when --skip-grant-tables

Submitted: 11 Nov 2004 13:22 Modified: 11 Nov 2004 18:28
Reporter: Arjen Lentz Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.0.18 OS:Any (any)
Assigned to: CPU Architecture:Any

[11 Nov 2004 13:22] Arjen Lentz 
Description:
When starting mysqld with --skip-grant-tables, and you do
SELECT CURRENT_USER()
the result is "user@0"

I presume the host name should be blank rather than "0";

How to repeat:
mysqld --skip-grant-tables --user=mysql

SELECT CURRENT_USER();
[11 Nov 2004 18:28] MySQL Verification Team 
Can't repeat it with 4.0.22

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.048 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.