Name

USER( )

Synopsis

USER( )

This function returns the username and the hostname for the current MySQL connection. There are no arguments for the function. It’s synonymous with SESSION_USER( ) and SYSTEM_USER().

SELECT USER( );
+-------------------+
| USER( )            |
+-------------------+
| russell@localhost |
+-------------------+

Get MySQL in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.