MySQL select user() and show processlist Commands

The select user() command shows who you are logged in as:

 

UNIX > mysql -u andrew -p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 37

Server version: 5.5.19 MySQL Community Server (GPL)

 

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

 

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

 

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

 

mysql> use test;

Database changed

mysql> select user();

+------------------+

| user()           |

+------------------+

| andrew@localhost |

+------------------+

1 row in set (0.00 sec)

 

mysql>

 

... and the show processlist command shows who is logged in. I had to shrink it so that it would fit in the screen. The time column shows how long the user has been logged in for in seconds:

 

UNIX > mysql -u root -p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 38

Server version: 5.5.19 MySQL Community Server (GPL)

 

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

 

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

 

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

 

mysql> show processlist;

+----+--------+-----------+------+---------+------+-------+------------------+

| Id | User   | Host      | db   | Command | Time | State | Info             |

+----+--------+-----------+------+---------+------+-------+------------------+

| 37 | andrew | localhost | test | Sleep   |  237 |       | NULL             |

| 38 | root   | localhost | NULL | Query   |    0 | NULL  | show processlist |

+----+--------+-----------+------+---------+------+-------+------------------+

2 rows in set (0.00 sec)

 

mysql> show processlist;

+----+--------+-----------+------+---------+------+-------+------------------+

| Id | User   | Host      | db   | Command | Time | State | Info             |

+----+--------+-----------+------+---------+------+-------+------------------+

| 37 | andrew | localhost | test | Sleep   |  248 |       | NULL             |

| 38 | root   | localhost | NULL | Query   |    0 | NULL  | show processlist |

+----+--------+-----------+------+---------+------+-------+------------------+

2 rows in set (0.00 sec)

 

mysql>