登陆mysql后,如何查看当前用户

时间:2022-11-16 05:22:00

登陆mysql后,如何查看当前用户呢

方法有二,如下:

 

1. 用函数user()

 

mysql> select user();
+----------------+
| user()         |
+----------------+
| wang@localhost |
+----------------+
1 row in set (0.00 sec)

2. 在用status 查看库状态信息中也包含当前用户信息

mysql> status
--------------
mysql  Ver 14.14 Distrib 5.6.14, for linux-glibc2.5 (x86_64) using  EditLine wrapper

Connection id:          12
Current database:       example
Current user:           wang@localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         5.6.14-enterprise-commercial-advanced MySQL Enterprise Server - Advanced Edition (Commercial)
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    gbk
Db     characterset:    gbk
Client characterset:    utf8
Conn.  characterset:    utf8
UNIX socket:            /tmp/mysql.sock
Uptime:                 2 hours 6 min 56 sec

Threads: 2  Questions: 279  Slow queries: 0  Opens: 105  Flush tables: 1  Open tables: 84  Queries per second avg: 0.036