mysql: whoami ?

Question

Is there a whoami-like function in mysql?

I'm connecting to the mysql command line from a remote host. I'm not sure if my ip address is resolving to a domain name or not. I would like to see something like

mysql> whoami;
+----------------------------------+
| User     | Host                  |
+----------------------------------+
| username | resolved.hostname.com |
+----------------------------------+
1 row in set (0.00 sec)

or

mysql> whoami;
+------------------------+
| User     | Host        |
+------------------------+
| username | 22.66.88.44 |
+------------------------+
1 row in set (0.00 sec)

Answer 1

Just do a...

select user,host from mysql.user;

Should show you what you want.

Answer 2

Use the CURRENT_USER and/or USER functions:

SELECT CURRENT_USER();

SELECT USER();

Put shortly, CURRENT_USER shows who you tried to authenticate as, while USER shows who you are authenticated as.

See the MySQL manual for more information.

Answer 3

If you are using mysql command line utility then try \s command:

mysql> \s
--------------
mysql  Ver 14.12 Distrib 5.0.67, for suse-linux-gnu (i686) using readline 5.2

Connection id:          519
Current database:
Current user:           admin@localhost
.........
Server version:         5.0.67 SUSE MySQL RPM
.........