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.

Note that 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 current active role.

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                    |
+----------------------------------+

URL: https://mariadb.com/kb/en/user/