Step to Change Permissions for a Database User

Changing permissions for a database user in the Aviums Host control panel is an important task for managing database access and security. Here's a step-by-step guide on how to do this:

Step 1: Log Into Your Aviums Host Account

  1. Visit Aviums Host: Open your web browser and navigate to the Aviums Host website.
  2. Sign In: Enter your username and password to access your account dashboard.

Step 2: Access the Control Panel

  1. Navigate to the Control Panel: Once logged in, locate and click on the Control Panel or cPanel link from your account dashboard.

Step 3: Locate the Database Section

  1. Find MySQL Databases: In the control panel, scroll down to the Databases section.
  2. Click on MySQL Databases: Select MySQL Databases to open the database management interface.

Step 4: Assign or Change User Privileges

  1. Scroll to Add User to Database: In the MySQL Databases section, scroll down to the Add User to Database area.
  2. Select User and Database:
    • In the first dropdown, select the user whose permissions you want to change.
    • In the second dropdown, select the database you want to modify permissions for.
  3. Click Add: After selecting the user and database, click the Add button.

Step 5: Modify User Privileges

  1. Set Privileges: After clicking Add, you will see a list of privileges you can grant to the user for the selected database.
    • All Privileges: Grants the user full access to the database.
    • Specific Privileges: You can check or uncheck boxes for specific permissions like SELECT, INSERT, UPDATE, DELETE, etc.
  2. Click Make Changes: Once you've selected the desired privileges, click the Make Changes button to apply the new permissions.

Step 6: Confirm Changes

  1. Confirmation Message: After saving, you should see a confirmation message indicating that the permissions have been successfully updated.
  2. Review Permissions: To ensure the permissions are set correctly, you can return to the Add User to Database section and repeat the process to check the current privileges for the user.
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Aviums Host Database Management System

A Database Management System (DBMS) serves as an essential interface for overseeing databases,...

Step to Create a New MySQL Database

Follow these steps to create a new MySQL database in the Aviums Host control panel: Step 1: Log...

Step to Manage MySQL Databases

Managing MySQL databases is a crucial aspect of maintaining your web applications and websites....

To locate the details of your MySQL database

Locating the details of your MySQL database in the Aviums Host control panel is essential for...

Step to Change a Database Password

Changing a database password in the Aviums Host control panel is a straightforward process that...