USER

Return the current MariaDB user. This function returns the user name and host name provided by the client upon connection.

Syntax

USER()

Description

Returns the current MariaDB user name and host name, given when authenticating to MariaDB, as a string in the utf8 character set.

The value of USER() may differ from the value of CURRENT_USER(), which is the user used to authenticate the current client. CURRENT_ROLE() returns the currently active role.

Current

SYSTEM_USER() is a synonym for USER().

< 11.7

Statements using the USER() function or one of its synonyms are not safe for statement level replication.

Examples

shell> mysql --user="anonymous"

SELECT USER(),CURRENT_USER();
+---------------------+----------------+
| USER()              | CURRENT_USER() |
+---------------------+----------------+
| anonymous@localhost | @localhost     |
+---------------------+----------------+

To select only the IP address, use SUBSTRING_INDEX(),

SELECT SUBSTRING_INDEX(USER(), '@', -1);
+----------------------------------+
| SUBSTRING_INDEX(USER(), '@', -1) |
+----------------------------------+
| 192.168.0.101                    |
+----------------------------------+

See Also

• CURRENT_USER()

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}