How to change permissions for MySQL users

How to change permissions for MySQL users

This article shows how Nexcess clients on physical (non-cloud) servers can use SiteWorx to change permissions for MySQL users.


ATTENTION: This method is only available to Nexcess clients on physical (non-cloud) servers. If you are a Nexcess Cloud client, please contact our Support Team by email or through the Client Portal for assstance. 

  1. Log in to your SiteWorx account.

  2. From the SiteWorx main menu, click Hosting Features > MySQL > Databases.

  3. In the Existing Database section, locate the relevant database, then click Manage Users. 

  4. You may view existing permissions for all users in the Existing Permissions section. To edit a user's permissions, from the User drop-down list, select the user, then select or clear the appropriate check box corresponding to each permission.

  5. Click Save.

User permissions

The following table defines the permissions available for application to a specific MySQL Database user account.

User PermissionsOperations Allowed
Select Select rows from tables in the database.
Create Create new databases or tables.
Alter Alter the table structure.
Show View Show views.
Insert Insert rows into tables.
Drop Drop or remove existing databases and tables. If this permission is enabled for a user, the user will be able to drop the database in which the MySQL access privileges are stored.
Create Temporary Table Create temporary tables.
Create Routine Create stored routines, procedures, and functions.
Update Update database table rows and data.
References Not currently used.
Lock Tables Lock tables in the database.
Alter Routine Modify or alter stored routines.
Delete Delete data and rows in database tables.
Index Create or remove indexes.
Create View Create a new view.


For 24-hour assistance any day of the year, contact our Support Team by email or through the Client Portal.

Article Rating (No Votes)
Rate this article
  • Icon PDFExport to PDF
  • Icon MS-WordExport to MS Word
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
How to use SiteWorx to install ExpressionEngine
Added on Mon, Jan 14, 2019
How to configure DNS records in SiteWorx
Added on Wed, Mar 13, 2019
How to truncate MySQL tables in SiteWorx
Added on Mon, Dec 17, 2018
How to download backup files with SiteWorx
Added on Tue, Dec 18, 2018
How to enable SSH access
Added on Mon, Dec 17, 2018
How to repair MySQL tables
Added on Fri, Sep 14, 2018
How to add client accounts as a reseller
Added on Mon, Oct 22, 2018
How to generate CSRs
Added on Thu, Jun 7, 2018
How to show running MySQL queries in Nexcess Cloud
Added on Mon, Dec 17, 2018
How to configure Magento 2 to use Elasticsearch
Added on Fri, Feb 22, 2019