Assign Database Privileges

From Webuzo Wiki
Jump to: navigation, search

Overview

This guide shows you how to Add a Database User to a Particular Database and assign privileges to the same using Webuzo.


Navigate

You can create a Add a Database User to a Particular Database and assign privileges to the same from Webuzo Enduser Panel > Database > Manage Database
Nav manage database.png


Procedure

  • Click on the Add User to Database Tab on the landing page

DB5.png

  • Select the Database Username from the DropDown List
  • Select the Database Name from the DropDown List
  • Then click on Add button and a Privileges Box will pop-up.
  • Set the permission for your database, i.e the user can Create, Execute, Drop, Lock tables in your Database.

Privilges.png

  • You can also set the Host for the Database User for that Particular Database


Required Inputs

  • Database Username - NAME of the database Username
  • Database Name - NAME of the database
  • Database Privileges - Tick the Privileges to Assign to the Database User for a particular database.
  • Database Host - Localhost / Remote Host / Any Host