MySQL USER() Function

Example

Return the current user name and host name for the MySQL connection:

SELECT USER();
Try it Yourself »

Definition and Usage

The USER() function returns the current user name and host name for the MySQL connection.

Note: This function is equal to the SESSION_USER() function and the SYSTEM_USER() function.

Tip: Also look at the CURRENT_USER() function.

Syntax

USER()

Technical Details

Works in: From MySQL 4.0

Copyright 1999-2023 by Refsnes Data. All Rights Reserved.