Check the current user in MySQL command line

Question

Here is my question about MySQL.

After I log in to MySQL using:

mysql -u myname -p
...
mysql>

I wanted to know what the username I used to logon. Is there a way to check this? like "whoami" in unix?

Thanks.

possible duplicate of Is there a way to know your current username in mysql? — Jens
– Jens, Commented Feb 23, 2015 at 6:20

Ataboy Josef · Accepted Answer · 2015-02-23 06:21:36Z

44

There is a MYSQL function user(). To get the user:

SELECT USER();

This will return something like username@hostname.

answered Feb 23, 2015 at 6:21

Ataboy Josef

2,1113 gold badges24 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ataboy Josef Over a year ago

mysql> STATUS; will list all info, if you need to do this from console. (dev.mysql.com/doc/refman/5.0/en/installation-version.html)

Purushothaman Srikanth Over a year ago

Please update the URL which u have added.

Super Kai - Kazuya Ito · Accepted Answer · 2023-11-10 16:35:22Z

0

You can show the current user with CURRENT_USER(), CURRENT_USER or USER() as shown below. *My answer also explains the difference between CURRENT_USER() or CURRENT_USER and USER():

SELECT CURRENT_USER();

Or:

SELECT CURRENT_USER;

Or:

SELECT USER();

answered Nov 10, 2023 at 16:35

Super Kai - Kazuya Ito

42.8k23 gold badges258 silver badges257 bronze badges

Collectives™ on Stack Overflow

Check the current user in MySQL command line

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related