Contact
Site: US UK AU |

How to change permissions for MySQL users

How to change permissions for MySQL users

Overview
This article demonstrates how to change an existing user's permissions in a MySQL database.

Procedure

  1. Log in to your SiteWorx account.

  2. From the SiteWorx main menu, click Hosting Features > MySQL > Databases (Figure 1).


    Figure 1. SiteWorx main menu, Hosting Features > MySQL > Databases.

  3. In the Existing Database section, locate the relevant database, then click Manage Users (Figure 2). 


    Figure 2. Existing Databases section; 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 (Figure 3).


    Figure 3. MySQL Database Management section; User drop-down list and permission check boxes.

  5. Click Save.

User permissions

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

User Permissions Operations 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.
Execute Execute stored routines, procedures and functions.
Article Rating (1 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 enable Let’s Encrypt
Added on Fri, Jul 27, 2018
How to purchase a Wildcard SSL certificate
Added on Wed, Jan 14, 2015
How to download backup files with SiteWorx
Added on Tue, Aug 6, 2013
How to change email account passwords in SiteWorx
Added on Mon, Aug 5, 2013
How to truncate MySQL tables
Added on Fri, Oct 30, 2015
How to generate a CSR
Added on Thu, Jun 7, 2018
How to add secondary domains with SiteWorx
Added on Fri, Jun 1, 2018
What is SiteWorx?
Added on Thu, Aug 28, 2014
Changing the password for a MySQL database user
Added on Tue, Jul 30, 2013
How to configure DNS records in SiteWorx
Added on Tue, Jul 31, 2018