If you like to grant a user special privileges, like for example, only run select queries on a table, then PHPMyAdmin is your friend.

1. Go to the user settings
2. leave the global settings blank
3. under database specific, choose your database.
4. in the table specific, opt for the table you wish to add.
5. in the select column, select all fields that can be used for select queries.
6. check show_view and Create_view

That’s all :)

Leave a Reply

Your email address will not be published. Required fields are marked *