Assign Database Privileges

Posted at March 5, 2016 at 9:24 pm by Manoj Kumar

Navigate

You can create a Add a Database User to a Particular Database and assign privileges to the same from Bread Basket Panel > Database > Manage Database

Nav_manage_database

Procedure

  1. Click on the Add User to Database Tab on the landing page

DB5     2. Select the Database Username from the DropDown List

3. Select the Database Name from the DropDown List

4. Then click on Add button and a Privileges Box will pop-up.

5. Set the permission for your database, i.e the user can Create, Execute, Drop, Lock tables in your Database.

Privilges

6. You can also set the Host for the Database User for that Particular Database

Required Inputs

  1. Database Username – NAME of the database Username
  2. Database Name – NAME of the database
  3. Database Privileges – Tick the Privileges to Assign to the Database User for a particular database.
  4. Database Host – Localhost / Remote Host / Any Host
0.00 avg. rating (0% score) - 0 votes

You can skip to the end and leave a response. Pinging is currently not allowed.

Leave a Reply