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