Saari Development

Ali Rizvi's Technical Blog as a Professional Software Development Engineer

MySQL: Display permissions on different databases

with one comment

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 |
+-----------+-------------------+-------+-------------+-------------+-------------+-------------+-------------+-----------+------------+
Advertisements

Written by imsaar

December 10, 2005 at 11:35 pm

Posted in general

One Response

Subscribe to comments with RSS.

  1. Good Day Ali, I just did a search for personal development and for some reason your site was highlighted! I have a real interest in MySQL: Display permissions on different databases and was hoping your site could lead me to more info. Unfortunately it did not have any sources for personal development
    Thanks Anyway!
    PS: I really enjoyed your read even though it was not what I had anticipated.

    jimmy

    December 11, 2005 at 10:31 am


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: