MySQL Tutorial MySQL Advanced MySQL Database Account Management MySQL References

MySQL USER() Function



The MySQL 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 USER() function.

Syntax

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 USER() function.

mysql> SELECT 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 USER();
Result: 'root@alphacodingskills.com'

❮ MySQL Functions