We use cookies to understand how you interact with our site, to personalize and streamline your experience, and to tailor advertising. By continuing to use our site, you accept our use of cookies and accept our Privacy Policy.
Contact Us
Contact Us
Sign in
Sign in
Nexcess Logo

How to change permissions for MySQL users

September 10, 2019

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

Method

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
SelectSelect rows from tables in the database.
CreateCreate new databases or tables.
AlterAlter the table structure.
Show ViewShow views.
InsertInsert rows into tables.
DropDrop 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 TableCreate temporary tables.
Create RoutineCreate stored routines, procedures, and functions.
UpdateUpdate database table rows and data.
ReferencesNot currently used.
Lock TablesLock tables in the database.
Alter RoutineModify or alter stored routines.
DeleteDelete data and rows in database tables.
IndexCreate or remove indexes.
Create ViewCreate a new view.
Execute


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

Jason Dobry