SELECT host, user, select_priv, update_priv FROM user
mysql> use mysql Database changed mysql> SELECT host, user, select_priv, update_priv FROM user; +------------+------+-------------+-------------+ | host | user | select_priv | update_priv | +------------+------+-------------+-------------+ | localhost | root | Y | Y | | production | root | Y | Y | | 127.0.0.1 | root | Y | Y | +------------+------+-------------+-------------+ 3 rows in set (0.03 sec)
mysql>
Related Scripts with Example Source Code in same category :
