sqlmysqldatabasemysqlcommandmysql-command-line-client

Show the current username in MySQL?

I would like to know if there's a way for a mysql query to return the username of the user that issues the query.

Is this possible?

Solution

  • Try the CURRENT_USER() function. This returns the username that MySQL used to authenticate your client connection. It is this username that determines your privileges.

    This may be different from the username that was sent to MySQL by the client (for example, MySQL might use an anonymous account to authenticate your client, even though you sent a username). If you want the username the client sent to MySQL when connecting use the USER() function instead.

    The value indicates the user name you specified when connecting to the server, and the client host from which you connected. The value can be different from that of CURRENT_USER().

    http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_current-user