登陆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