find username,databasename and version in mysql?

Question

while using database under MySQL how can i determine my current MySQL version,database name I'm working and logged in username ?

is it possible to get through using query ?

Answer 1

Try this.

mysql> select version(),user(),database();
+-----------+----------------+------------+
| version() | user()         | database() |
+-----------+----------------+------------+
| 5.1.41    | root@localhost | bank       |
+-----------+----------------+------------+
1 row in set (0.00 sec)