MySQL: Display permissions on different databases

mysql> select Host, DB, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Alter_priv from db;


+-----------+-------------------+-------+-------------+-------------+-------------+-------------+-------------+-----------+------------+
| Host | DB | User | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Alter_priv |
+-----------+-------------------+-------+-------------+-------------+-------------+-------------+-------------+-----------+------------+
| % | test | | Y | Y | Y | Y | Y | Y | Y |
| % | test\_% | | Y | Y | Y | Y | Y | Y | Y |
| localhost | depot_development | rizvi | Y | Y | Y | Y | Y | Y | Y |
| localhost | depot_production | rizvi | Y | Y | Y | Y | Y | Y | Y |
| localhost | depot_test | rizvi | Y | Y | Y | Y | Y | Y | Y |
| localhost | depot_production | prod | Y | Y | Y | Y | Y | Y | Y |
+-----------+-------------------+-------+-------------+-------------+-------------+-------------+-------------+-----------+------------+
One Response
  1. December 11, 2005