how do I see which user I am logged in as in MySQL?

Question

I have multiple text console session open and log in as different users into different consoles. I forget after while which consoles belong to which user, it would be nice to not have to quit and log back in.

How do I see which user I am logged in as?

Is there a way to change which user I logged in as with out logging out?

RolandoMySQLDBA · Accepted Answer · 2011-09-09T16:56:41.923

60

Actually, you need to use two functions

SELECT USER(),CURRENT_USER();

USER() reports how you attempted to authenticate in MySQL

CURRENT_USER() reports how you were allowed to authenticate in MySQL

Sometimes, they are different

edited Sep 09 '11 at 16:56

answered Apr 16 '11 at 02:29

RolandoMySQLDBA

3,215

score 2 · Answer 2 · answered Apr 05 '11 at 07:56

2

I found this user() function

select user(); Will show you which user is logged in.

answered Apr 05 '11 at 07:56

nelaaro

14,139
30
88
115

JohnW. · Answer 3 · 2014-10-30T05:14:41.810

2

You can use 'status':

MariaDB [my_database]> status

Current user: root@localhost

edited Oct 30 '14 at 05:14

answered Oct 30 '14 at 05:01

JohnW.

21

score 1 · Answer 4 · answered Apr 05 '11 at 07:55

1

Does

select user();

work?

I pinched it from the 3rd google result for 'mysql whoami':

answered Apr 05 '11 at 07:55

Pricey

4,710

how do I see which user I am logged in as in MySQL?

4 Answers4

Linked