MySQL SESSION_USER() Function

The MySQL SESSION_USER() function returns the user name and host name for the current MySQL user. The user name is the name of the user specified when connecting to the server and the host name is the name of the client host that the user connected from.

The SESSION_USER() and SYSTEM_USER() functions are synonyms for the USER() function. Note that, the CURRENT_USER() function can return a different value than the SESSION_USER() function.

Syntax

SESSION_USER()

Parameters

No parameter is required.

Return Value

Returns the user name and host name for the current MySQL user.

Example:

The example below shows the usage of SESSION_USER() function.

mysql> SELECT SESSION_USER();

The above query will return the user name and host name for the current MySQL user. Therefore if the user name specified when connecting to the server was 'root' and the name of the client host that the user connected from was 'alphacodingskills.com' it will return the following:

mysql> SELECT SESSION_USER();
Result: 'root@alphacodingskills.com'