mysql> SELECT USER();
+----------------------+
| USER() |
+----------------------+
| yisile@192.168.2.213 |
+----------------------+
1 row in set (0.00 sec)
mysql> seLECT User();
+----------------------+
| User() |
+----------------------+
| yisile@192.168.2.213 |
+----------------------+
1 row in set (0.00 sec)
mysql> select current_user();
+----------------+
| current_user() |
+----------------+
| yisile@% |
+----------------+
1 row in set (0.01 sec)
mysql> select current_user();
+----------------+
| current_user() |
+----------------+
| yisile@% |
+----------------+
1 row in set (0.00 sec)
mysql> select database();
+------------+
| database() |
+------------+
| NULL |
+------------+
1 row in set (0.00 sec)
mysql> use yisile;
Database changed
mysql> select database();
+------------+
| database() |
+------------+
| yisile |
+------------+
1 row in set (0.00 sec)
mysql> use mysql;
Database changed
mysql> select database();
+------------+
| database() |
+------------+
| mysql |
+------------+
1 row in set (0.00 sec)
mysql> select version();
+------------------------+
| version() |
+------------------------+
| 5.5.0-m2-community-log |
+------------------------+
1 row in set (0.00 sec)
mysql> select session_user(),system_user();
+----------------------+----------------------+
| session_user() | system_user() |
+----------------------+----------------------+
| yisile@192.168.2.213 | yisile@192.168.2.213 |
+----------------------+----------------------+
1 row in set (0.00 sec)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9240380/viewspace-665807/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9240380/viewspace-665807/