Mega Code Archive

 

Categories / MySQL Tutorial / Privilege

 

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>