MySQL CURRENT_USER() Function

 The CURRENT_USER() function in MySQL is used to return the current authenticated MySQL user, as specified by the MySQL server at the time of the user's connection. It provides information about the user, including the username and the host from which they are connected.

Syntax:

CURRENT_USER()

Return Value:

• A string containing the user name and host in the form: user_name@host_name.

Key Points:

• The value returned by CURRENT_USER() reflects the user that MySQL used for authentication when the connection was established.
• This is not the same as the USER() function, which returns the current user in the form user_name@host_name but might reflect changes due to privilege escalation (e.g., through GRANT or SET statements).
• CURRENT_USER() is particularly useful in debugging, logging, and auditing scenarios where it's important to know who actually authenticated.

Example:

SELECT CURRENT_USER();

Output:

'username@hostname'

If you connected as admin from localhost, the output might be:

'admin@localhost'