check current user in mysql command line

Question

Here is my question about mysql.

After i logon 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.

Answer 1

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

SELECT USER();

This will return something like username@hostname.