USER

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

SYSTEM_USER() and SESSION_USER are synonyms for USER().

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}