Curriculum
Course: SQL
Login

Curriculum

SQL

SQL References

0/80

MySQL Functions

0/139

SQL Server Functions

0/84

SQL Quick Ref

0/1
Text lesson

CURRENT_USER

Example

Retrieve the user name and host name associated with the MySQL account.

SELECT CURRENT_USER();

Definition and Usage

The CURRENT_USER() function retrieves the user name and host name of the MySQL account that authenticated the current client connection to the server.

The result is returned as a string in the UTF8 character encoding.

Tip: Also refer to the USER() function for related information.

Syntax

CURRENT_USER()

Technical Details

Works in:

 From MySQL version 4.0