©SQL :: Manager
HomeProgram InformationTechnical detailsFree downloadDonate for a cup of coffee
myway SQL Manager for MySQL and MariaDB, Download on Uptodown
SQL functionMySQLMariaDB

The USER SQL Function in MySQL and MariaDB - Host and username

USERSyntax:USER()
Return value:CHAR
Synonyms:SESSION_USER, SYSTEM_USER
Function type:Information function
Function Description

The USER() function returns the current username and hostname provided during authentication.

The value of USER() can be different from the value of CURRENT_USER() because it is the user used to authenticate the current client.

SQL Examples for the USER function

 1
 2
 3

SELECT user();

user()
varchar(288) BINARY
root@localhost
The examples were created with the MyWAY SQL manager: Download

How to use the USER() function in MySQL and MariaDB databases

In MySQL and MariaDB the USER() function is used to get the current combination of username and host for the database session and return it as a string. The function requires no arguments and can be used directly in SQL statements or within SQL queries.

For example, the USER() function is used to determine the current user for the database session so that authentication and authorization logic can be implemented based on the user's identity. USER() can be used for monitoring or logging purposes to allow tracking of user activity within the database. The retrieved user information can also be used in conditional statements or queries to perform various actions based on the user's identity, such as assigning specific logic or permissions to different users or groups of users.

The returned username and host combination may depend on the specific authentication mechanisms used by database servers. For security reasons, the username can be an encrypted.
UNHEXUNIX_TIMESTAMPUPPERUSERUTC_DATEUTC_TIMEUTC_TIMESTAMP

Further MySQL und MariaDB SQL Information functions

BENCHMARKBENCHMARK(Number, Expression)
More about BENCHMARK Function

BINLOG_GTID_POSBINLOG_GTID_POS()

CHARSETCHARSET(String)
More about CHARSET Function

COERCIBILITYCOERCIBILITY(String)
More about COERCIBILITY Function

COLLATIONCOLLATION(String)
More about COLLATION Function

CONNECTION_IDCONNECTION_ID()
More about CONNECTION_ID Function

CURRENT_USERCURRENT_USER()
More about CURRENT_USER Function

CURRENT_ROLECURRENT_ROLE()
More about CURRENT_ROLE Function

DATABASEDATABASE()
More about DATABASE Function

DECODE_HISTOGRAMDECODE_HISTOGRAM()

DEFAULTDEFAULT(Column)
More about DEFAULT Function

FOUND_ROWSFOUND_ROWS()
More about FOUND_ROWS Function

LAST_INSERT_IDLAST_INSERT_ID([Expression])
More about LAST_INSERT_ID Function

LAST_VALUELAST_VALUE(Expression [, Expression ...])
More about LAST_VALUE Function

ROWNUMROWNUM()

ROW_COUNTROW_COUNT()
More about ROW_COUNT Function

SCHEMASCHEMA()
More about SCHEMA Function

SESSION_USERSESSION_USER()
More about SESSION_USER Function

SYSTEM_USERSYSTEM_USER()
More about SYSTEM_USER Function

VERSIONVERSION()
More about VERSION Function

Numeric functionsString functionsRegular ExpressionsDate and Time functions
Comparison functionsEncryption & CompressionConversion functionsNULL functions
Aggregate functionsWindow functionsJSON functionsGeometric functions
Sequence functionsInformation functionsDynamic ColumnsMiscellaneous functions
More information about the USER SQL function: mysql.com and mariadb.com
Updated: 2023-09-17ImprintContactTerms & conditionsPrivacy & CookiesUpdatesSitemapFacebookLinkedinTwitterStatistics©2020-2024 Heino Cunze-Fischer