查看mysql数据用户权限_查看MYSQL数据库中所有用户及拥有权限

查看user表结构需要具体的项可结合表结构来查询 mysql> desc mysql.user; +-----------------------+-----------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------------+-----------------------------------+------+-----+---------+-------+ | Host | char(60) | NO | PRI | | | | User | char(16) | NO | PRI | | | | Password | char(41) | NO | | | | | Select_priv | enum('N','Y') | NO | | N | | ****************** ****************** +-----------------------+-----------------------------------+------+-----+---------+-------+ 39 rows in set (0.00 sec)