USER()
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.
SYSTEM_USER()
is a synonym for USER()
.
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.
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 |
+----------------------------------+
This page is licensed: GPLv2, originally from fill_help_tables.sql