Is there a way to know your current username in mysql?
MysqlMysql Problem Overview
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?
Mysql Solutions
Solution 1 - Mysql
Try to run either
SELECT USER();
or
SELECT CURRENT_USER();
It can sometimes be different, USER() will return by which login you attempted to authenticate and CURRENT_USER() will return how you were actually allowed to authenticate.
Solution 2 - Mysql
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
Solution 3 - Mysql
Use this query:
SELECT USER();
Or
SELECT CURRENT_USER;
Solution 4 - Mysql
You can use:
SELECT USER();
or
SELECT CURRENT_USER();
See more here http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_current-user
Solution 5 - Mysql
to print the current user who is using the database
select user();
or
select current_user();
Solution 6 - Mysql
You can also use : mysql> select user,host from mysql.user;
+---------------+-------------------------------+
| user | host |
+---------------+-------------------------------+
| fkernel | % |
| nagios | % |
| readonly | % |
| replicant | % |
| reporting | % |
| reporting_ro | % |
| nagios | xx.xx.xx.xx |
| haproxy_root | xx.xx.xx.xx
| root | 127.0.0.1 |
| nagios | localhost |
| root | localhost |
+---------------+-------------------------------+
Solution 7 - Mysql
You can find the current user name with CURRENT_USER() function in MySQL.
for Ex:
SELECT CURRENT_USER();
But CURRENT_USER()
will not always return the logged in user. So in case you want to have the logged in user, then use SESSION_USER()
instead.
Solution 8 - Mysql
I needed such a feature and i used CURRENT_USER() but that gave me the Global Admin user which happens to be same for every query even if i changed the query username when connecting to the database. Obviously that is useless in the use case i was looking for. Then I used USER() and it gave me the username of the connection string that initiated the query. if i understood the question, this is what the person wanted in plain language. In my case, i used it in a trigger to track changes made to rows in a transaction table.