MySQL USER() Function

 The USER() function in MySQL returns the current MySQL user as a string in the format user_name@host_name. It can be useful for identifying the MySQL account currently in use for executing queries.

Syntax:

USER();

Example:

1. Basic Usage:

   SELECT USER();
   

   Output:

   'root@localhost'
   

2. Using in a query:

   SELECT USER(), CURRENT_USER();
   

   • USER() returns the current MySQL user (the user who executed the query).
   • CURRENT_USER() returns the authenticated MySQL user (the user MySQL is using to validate the connection).

Notes:

• The value returned by USER() includes the hostname (@host) part, indicating from where the user is connecting.
• If you are using MySQL with a non-root account, the output will reflect the username and host for that specific account.