mysql常用命令2

1、查看所有用户

      select  * from mysql.user;

2、查看当前用户

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

3、查看当前系统日期

      select sysdate();